Thanks for the question. Firstly, most places have a power grid which is far larger than their locality. For example, the southeastern United States is connected to a single big grid which connects every smaller sub-grid east of the Rocky Mountains. This means that a home in Florida can be powered all the way from the Bath County pumped-storage facility in Virginia, the second largest such facility in the US.
Hydroelectricity can also be generated by rivers, which are commonly used in lowland areas, and geothermal is also viable at any time of the day. Biomass is also an option, though it’s the last resort really, although as long as it’s responsibly managed, it can be nearly carbon neutral.
There are also alternatives to pumped storage, lots of them. Compressed air, thermal storage, and hydrogen are a few examples just off the top of my head, though I’m sure there are many more. Pumped storage is just very efficient and cheap, so if we can plausibly do it, it should be the first choice. And if it can’t be done somewhere, then we should connect that place to somewhere which can!