interesting turn of discussion: from technological options & economy to realistic individual and societal needs. One "technical"issue has not yet been covered; the difference in acuity needs with moving pictures versus stills as well as the effects of different movie compression systems. Both indicate considerably lower actual resolution needed and delivered .
No wonder that cineeastes often enjoy older lens designs.
For still photographers who would rather use a diffraction-limited wide angle rather than lug around a heavy and fragile zoom for then to crop the pictures,afterwards, however, resolution will remain an issue as long as the sensors can deliver.
Even with a plentiful and universal global supply of renewables with minimized climate impact, the chip foundries and the rest of the investments will entail a massive resource use and the economkics of the entire edifice will still have to compete with mobile phones and other fashions.
p.