Phase change stores/requires much more energy than simple temperature change. 0°C Ice to 0°C water transition is 334J/g, 0C water to 100C water is ~400J/g (ie 4J/g per degree C), 100C water to 100C steam is 2260J/g.
To store heat from the summer for winter warming (say best case 40C summer temp) you'd be looking at least 3x as much material for heat storage vs ice storage for summer cooling (at say -10C)
(Yeah, I know I'm being both pedantic and off topic, since the discussion here is specifically about seasonal storage)
I believe at least one university on the Great Lakes does heating and cooling with pipes deep under the lake.
And the city of Toronto uses lake water for cooling. Heat from a downtown cooling loop is dumped into the city's drinking water supply, bringing the temperature up to around 13° from 6° (if I remember correctly).
Unless I misunderstood, the Toronto Zoo has or had such a system setup for one or more of the food pavilions.
What's interesting about this is that the storage grows with the volume (n^3), but the heat/cold loss grows with the surface area (n^2). So you're ability to 'store cold' gets better as you get bigger.
Just the same, you could also use it backwards in the winter time. On hot, sunny days at the end of the summer, warm up the water stored.