You're right that the current state of battery tech is woefully inefficient for any kind of grid-level storage.

But energy can be stored by pumping heated water to deep wells in the bedrock for example or you can use excess power to generate hydrogen and feed it back to the grid via fuel cells when needed. All of this is doable, but also slow to build and currently expensive.