In the US, public opinion has nearly nothing to do with the lack of new construction. The problem is far simpler here: nobody can build a reactor reliably without going vastly over budget, or off schedule. Going off schedule also means going off budget because costs are front loaded over the 40-60 year lifespan and therefore every year of delay costs massive amounts of interest.
There are plenty of viable sites for nuclear in the US where the local population is eager and willing, usually where there's already a nuclear power plant and it forms a strong economic force for the area. The NRC can't wait to approve more reactors and is doing its best to come up with new ways to certify safety.
So why wasn't nuclear built? Project management failures in the 1970s, combined with utility management far overestimating demand, led to a glut of reactors that were gigantic losses for those trying to build them. This was happening before TMI and Chernobyl turned more public opinion against nuclear. There's a great historical article about this management failure from the 1980 in Forbes that is escaping my web searches at the moment, but the massive financial losses taught the money guys to stay the hell away from nuclear.
Fast forward to the 2000s, there's a renewed push to build more reactors, especially as the current fleet ages and will need to be retired. Nobody wants to do it, because of massive financial risk for little gain. Finally, regulatory capture of the Georgia and North Carolina state legislatures enables bills so that the utitlties socialize all risks of construction failure into their ratepayers, while keeping the profits privatized. Only in that remarkable situation would any utility be willing to take on the insane risk of trying to build a reactor. Four were attempted, two have been abandoned, and North Carolina electricity customers pay something like an average of $20/month on their bill for reactors that will never get completed. Georgia is behind schedule, 2x-3x over budget at the moment, with no end in sight of the cost overruns.
So it's not public opinion that kills nuclear, it's nuclear construction that kills nuclear, at least in the US. We do not build massive projects well, and it blows out any sort of competitive nature for nuclear.
Even if nuclear costs 5x renewables stored in energy, there may still be a financial case for it being a part of a grid, just as peaker plants right now cost much more than, say, combined cycle gas turbines. But it seems unlikely that the massive GW+ reactors of yore will be attempted again any time soon. "Small" modular reactors in the 50MW range will be attempted next, even though in the past these were disregarded as too small to be cost effective. We shall see what their costs end up being, but the best I've been able to glean from news articles is that it's about the cost of Vogtle's new construction in Georgia, I.e. not going to be price competitive with batters and renewables in 10-15 years.
Building nuclear right now is a massively expensive bet on a technology that gets more expensive the more experience we have with it. Meanwhile it's competitors are getting cheaper every day. There may be a spot for it in the future grid, but only if it's boosters focus on nuclear's true problems rather than wasting effort on excuses that are not truly blocking the tech.