These guys are serious: Concrete flywheel storage system for residential PV – pv magazine International
It has to be very precisely balanced. They don’t mention a system price yet.
Metaphorically, this idea won’t take off, literally though, it will.
I like this one …
If you have a wife, installing something like that in your shower might yield a few kWhs every morning before sunrise and evening after sunset…