> 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.

You miss the part where nuclear fuel needs to be enriched. You don't just dig ore out of the ground and put it into a reactor. You need to enrich the fuel which means that much more ore needs to come out of the ground and be processed than the fuel end product.