Snow is a very good insulator due to all the trapped air, and it’s fairly easy to make thick walls (the same as straw-and-mud block construction - not the highest R value per cm thickness, but if the walls can be 50 cm thick, it adds up). So yeah, a proper snow cave will converge on freezing point - body heat plus lighting will heat to that point, after which the snow melts.