In the extreme case, you can get solar power in the middle of local night and winter by way of building a perfectly reasonable (one ohm resistance) global power grid for a reasonable material cost (260 or so billion USD at current aluminium prices, more for actually putting it wherever).
You'd still want storage for e.g. electric cars, and we aren't that coordinated globally, so I doubt we'd actually build a global grid; but I can easily believe we will see a unified north american continental grid once Texas gets out of its own way, or a unified EU+friends grid, and even at that scale you get several hours variation in sunrise and sunset, climate, and how long winter nights are.
Big deal as in expensive? Grid as a whole, not the wire itself, that's the point.
I'm seeing headlines about the USA needing to spend ten times that to modernise their grid. It isn't unreasonable to suspect the USA's grid modernisation could, for a very small increase in material cost, turn it into part of something much grander.
Big deal as in a political PitA at every level? Yup.
Storing fresh water is a good idea anyway. You don’t want to run out of that stuff :)
"Let's just use solar" comments are tiresome. It's not a panacea.
People think you slap some solar panels on your roof and it's "problem solved". Apparently they have no idea how the world consumes energy, or the scale:
https://www.penguinrandomhouse.com/books/666342/how-the-worl...
In "Transportation", there are a lot of non-electric consumption (in US in 2022: 89.45% oil, 5.7% biomass, 4.69% NatGas, only 0.08% electricity, and other) because only few trains and individual cars are using electricity the rest like boats, planes, and most trains in US runs on oil.
So, yes it is good for electric vehicles to charge during the day when solar produces the most. But the vast majority of the electricity consumption (in US 99.9%) is from the Industry, Commercial and Residential while the transportation is only in US 0.1% (source: https://flowcharts.llnl.gov/sites/flowcharts/files/2023-10/U...).
Most of the Industry, Commercial and even Residential needs electricity at night, and storing that kind electric energy (48.57 Quads per year... that is 9,246,178,571 barrel of oil or 0.2 barrel of U235) is currently difficult.