Some large cold storage facilities in Germany are trying to optimize electric demand to use cheap peak day electricity. But they have to observe limitations in range of temperatures and capacity of cooling devices.
https://www.cleanenergywire.org/news/cold-storage-facilities...
" Compared to conventional cold storage systems, renewable energy-driven cold storage demonstrates a 10–35 % reduction in energy losses"
https://www.sciencedirect.com/science/article/abs/pii/S23521...
A tank of water is cheap, it’s just not possible to distribute hot water over the grid. But it’s very realistic to store it locally and use for heating and cooling. Which is the bulk of power usage anyway.
I've been daydreaming about the tank of water idea as well, but the amount of panels you would need on the roof would be crazy.