At a statistical level, I'm willing to bet that driving a car is probably much more dangerous than living near either a nuclear plant or a fossil fuel plant, but we still do it.
The problem with nuclear power is, unlike fossil fuel plant or cars, an accident takes your home, your daily social connections, and your daily life. It turns you and your family and friends into refugees.
But the big shadow behind nuclear is weapons proliferation. From the 60s onwards nuclear bombs brought the possibility that there might be a civilisation-destroying nuclear exchange, and as the discourse around Iran has shown it's quite difficult for bystanders to distinguish between the two.
Banqiao Hydroelectric Dam, China, was breached Aug. 8 1975 killing more than 85,000 people that day. A study conducted by eight Chinese water science experts who probably had access to censored government reports, estimated the number of total dead — from flooding and the resulting epidemics and famine — at 230,000.
https://www.ozy.com/flashback/230000-died-in-a-dam-collapse-...
I think you're probably right that, even with frequent meltdowns, nuclear power would be less bad than coal. But I also think that we don't have a large enough number of disasters to extrapolate reliably. A hundred Chernobyls might produce much more than a hundred times the deaths from one Chernobyl — or much less.
The difference between nuclear's safety and fossil fuels anti-safety is astounding. They are not even remotely comparable. 4 million deaths per year from fossil, year after year. Up to 4000 total deaths across the decades from nuclear.
Fossil fuels are causing over 2 long-term cancer-included Chernobyls per day every single day right now.
This is an important point that's hard to get through to people.
In fact, building a straight-up Chernobyl reactor that runs for 5 years and then explodes is still safer than running a regular old coal plant for 5 years. Fossil is that bad.