After that huge push, we have nothing to show for it except for a tiny number of half-finished, over-budget, behind schedule construction projects, and a toooooon of abandoned projects. The UK can't even find somebody to build their projects anymore.
Hope has turned towards these small reactors, after the failure to build big reactors--despite immensely favorable regulatory, finance, and PR settings. I don't know of local opposition to a single reactor! At least not enough to cause a stir.
Thousands of small reactors won't be enough, and we won't be able to build thousands for another 10-20 years. So we are instead stuck with renewables and storage. And just like we were right to throw experimental money at nuclear in the mid-2000s when we didn't really believe the numbers, I think we are far better grounded to throw equal billions of dollars (at least $40B in the US) at storage projects that the industry currently disregards.
We have far better pricing data for storage, it's deployable within a year, and it has massive benefits. And investing now will decrease the cost more quickly.
Throw several billion each at more speculative storage techs like flow chemistries and cryogenic air storage, and then the rest at standard, shipping, off the shelf lithium ion. We will see massive industries come into formation whose economic productivity and value dwarfs the tiny $40B we spent on kickstarting it. This will work, without a doubt. Nuclear may or may not work, it remains to be seen.