I think long range transmission remains a thing anywhere having a local grid remains a thing (which will be most places for other reasons).
Load-balancing the area having a cloudy few days and the area having a sunny days and the area having a windy few days and so on will remain extremely valuable. It lets you install a lot less batteries and isn't that much infrastructure given that the last mile problems are dealt with already.
The point being made is that if smoothing over time becomes sufficiently cheap then smoothing over space is supplanted.
It would be nice if this happened before the next Carrington Event (or the next nuclear war with orbital EMP weapons.)
I think there is a calculation that makes the point a little clearer. There is some distance, x, where it is cheaper to transport the electrons mechanically than it is to push them over a wire. Every month that distance gets shorter as battery prices drop. This gets even more advantageous for batteries when you start talking about variable use and generation since it is easier to change the destination or source of a battery container than it is to change the destination or source of transmission lines. My main point is that that distance x is going to rapidly get towards just a few miles away from point of use very shortly. Imagine a small city getting a local electricity provider. I actually think the way it is likely to go is that energy consumers (cities, factories, etc) will start installing backup power via battery shipment and then slowly start disconnecting from the larger grid as the cost of the battery container delivered power dips below the cost for transmission line delivered. The infrastructure is just so much more efficient for most use cases because we already have that infrastructure for shipping other goods.