District heating already deploys rather large thermal storage in surprisingly compact volumes. The picture here is 2GWh:

https://en.wikipedia.org/wiki/District_heating#Heat_accumula...

When powered by heat pumps, I imagine this could be used for cooling in the summer as well.