Commercial and industrial use already makes up a large portion of demand. While the model will change to cater less to residential needs, overall demand for stable, high voltage generation is not going to go down.
We may see industrial users preposition themselves in locations with ample nearby PV potential. If I were building a factory in the US (or a data center) I would think twice before putting it in a higher population density area.
We may also see local microgrids develop. This would still have distribution costs, but not transmission.