Distributed power generation made sense when everyone used coal power plants - it was cheaper to ship trains full of coal than the power.
But if you want a carbon-free grid, then you can't ship the light or the wind. You either massively overbuild generation and throw most of the power away, build huge amounts of very expensive storage, or you ship the power.
Currently the world is headed towards overbuilding, but thats only because typically private companies build power generation, whereas power transport is mostly in the realm of governments, and governments are slower to act on market forces (and often aren't great at capital efficiency).
The end result will clearly be a mixture of all 3, but we're going to see a lot more power movement in the next 50 years than we saw in the last 50 years.