Earlier quoted context omitted.
Nuclear is superior in some ways, but battery and renewable is small, can be incrementally built, simple, safe, and is experiencing exponential cost reductions due to mass production scaling. It reminds me of TSMC leapfrogging Intel because of mobile volume or PCs vs custom Unix workstations.
The incremental build is probably a big part of it. More volume and minor failures = more practice time and experience. How does someone "practice" building a nuclear power plant when failure can be so catastrophic?
If we do make nuclear fission work it will be with modular reactors and standardized fuel form factors, etc.
Fusion won't fly even if we get over unity fusion unless we adopt a similar approach. Fusion reactors like to be big, but I can see them being composed of mass producible smaller modules and parts. Settling on a standard design that can be mass produced could make it work.
Thing is: as the nuclear people work to try to make anything above a reality, we are experiencing iterative rapid development in solar, wind, and batteries, with all of these getting geometrically cheaper until they approach the naked cost of the materials and the energy required to refine them... and the latter cost (energy) will drop as we get better at making these things.
In the long term I would not be surprised if Earth is almost 100% solar/wind/hydro/geothermal powered. You might see nuclear used in niche markets that combine high population density with low insolation and insufficient other resources and where geopolitical concerns make reliance on long distance power transport problematic. Earth is pretty close to a giant free fusion reactor that we don't need to worry about maintaining for at least two billion years. Nuclear power will be for space settlements further from the sun and deep space travel.
I could see Mars eventually relying on fusion in the far future. Mars is further from the sun, and most people who talk about settling there drastically underestimate the massive amounts of energy that will be needed to refine and purify literally every single material all the way down to the air and the water. The total energy footprint of your average Martian will be at least 10-20X your average Texan with a giant raised pickup and a 4000 square foot house.