At the moment, barring magical energy sources that haven't been proven in any meaningful sense, nuclear technology has shown itself to have the fewest long-term consequences and the highest efficiency. However, it is unfortunately also the easiest to point to a few events in history and easily make the layman cast doubt on its safety. It's worth pointing out that the most significant nuclear accident in history took place in the USSR (which wasn't particularly notorious for its safety protocols), on a reactor that had several known design flaws that were ignored, and the only other major accident representing a one in a thousand years perfect-storm that overcame several redundancies.
This concern about "drones" in relation to nuclear power plants is borderline paranoia. Are you concerned about drones dropping bombs or somehow disabling safety systems on a nuclear reactor? Every single nuclear power in the world has nuclear power plants, so they're all equally susceptible to the same attack in the same way that they're all equally capable of responding to said attack- mutually assured destruction as it goes.
A lot of the world's living population lived through Chernobyl, the various incidents at Sellafield and then Fukushima. All events that "statistically" should not have happened nearly as close together as they did - and that's without taking the risk of 9/11-style terrorism, actual acts of war (see Zaporizhzhia NPP) or catastrophic earthquakes into account.
There are only two kinds of power generation that have a mass-casualty potential: nuclear power plants and dammed hydro power (as evidenced by what went on at Kakhovka Dam). We should, as a species, get rid of these. The sooner, the better.
https://ourworldindata.org/safest-sources-of-energy
https://www.giss.nasa.gov/research/briefs/archive/2013_khare...
https://www.statista.com/statistics/494425/death-rate-worldw...
http://large.stanford.edu/courses/2019/ph241/marshall2/
https://www.engineering.com/story/whats-the-death-toll-of-nu...
Fly a plane into an NPP and you're looking at a massive contamination issue.
Hell, I live in Bavaria, and to this day you have to inspect shrooms and wild game meat for radiation - and it's likely to exceed safety thresholds, even decades after Chernobyl.
Or not: https://bigthink.com/the-present/nuclear-power-plant-survive...
The people at the Nova music festival in Israel would have said exactly the same thing as you in the hours before the event.
Black Swans can and do appear.
36 hours. That's all it takes.