Around here, transmission lines are copper clad steel above ground, aluminum underground. I ran across an article years ago that one of my college buddies, John Stovall, was Engineer In Charge of the "first commercial superconducting power line." If anybody could do it, John was the guy. He was scary smart. That was years ago and nothing ever came of it, so that technology is still waiting in the wings. Superconducting DC transmission lines would make wind power practical.
Redesigning the grid for distributed generation will certainly be expensive. I just saw an article that Switzerland (?) is experimenting with lining the space between rails with solar panels. Uploading the power to the rail lines would be convenient, but trains don't use that much power. I doubt rail lines could handle megawatts, particularly at their low voltages.