Long range transmission of AC power is limited to about 40 miles. DC can be transmitted much farther, but the infrastructure is substantially more expensive (because it’s more dangerous), so that’s only done for extreme need.
We aren’t getting away from having many power generators all over the place, so one location-dependent storage solution isn’t going to solve all the problems.