Simply comparing production figures without considering intermittency is one of the most common oversimplifications people make in decarbonization discussions.
Indeed there is much work to be done to drive fossil fuels out of all modes of transportation.
We're already noticing that wind farms can't be too close together, because upwind farms slow the wind, degrading the output of downwind farms. https://www.sustainability-times.com/low-carbon-energy/placi...
Solar is limited by available surface area, but more importantly by environmental impact. You're going to start destroying ecosystems if you blanket the land with panels.
Hydro has been mostly tapped out for a long time. At least in the developed world, all the geography that can be dammed, has been. And even here, there's a strong push from environmental groups to destroy the dams to restore ecosystems disrupted.
Lots of legacy fossil generation is going to end up stranded [2], from a capital markets perspective. No one is going to touch nuclear with their own capital, the LCOE speaks for itself [3]. Keep existing nuclear running as long as safe, but it'll sunset too eventually. Don't get mad at the math, it's just math.
[1] https://www.reuters.com/sustainability/us-power-regulator-we...
[2] https://www.nature.com/articles/s41558-022-01356-y
[3] https://lazard.com/media/2ozoovyg/lazards-lcoeplus-april-202...