> Nuclear fuel is several orders of magnitude more energy dense than solar or wind, so the amount of fuel required is shockingly low, especially compared to how many resources all those panels and windmills require to build and transport.

Uranium is rare and very unconcentrated so huge amounts of mining is required to get sufficient quantities. This is what a uranium mine looks like: https://en.wikipedia.org/wiki/Uranium_mining#/media/File:Ara...