You don't need to store that much energy. It's much more cost-efficient to over-provision energy sources. In a few decades we will see solar over-provisioned to 2-3x normal consumption and some battery and that will provide 100% uptime.
Falling battery prices helps of course but we are very far from a point where we can eliminate the need for hydrogen.
My opinion is that we need a mix of energy sources and we need a mix of energy storage solutions.