Making snow takes energy. (Basically, you need to spray a mist at high pressure, which includes pumping both water and air.)
Dams don't use energy once they're built. Hydropower is renewable and carbon-free.
Furthermore, if you're making snow to store water, you can't control when it melts, and you need to collect the water as it melts, most likely behind some kind of a dam!