And you think that the public would want a nuclear reactor in their neighborhood?
Sure. Why not? The only reason the public is scared of nuclear power is because of safety, and ironically, the only reason nuclear plants are unsafe is because the public is scared of nuclear power. Were it not for NIMBY behavior decades ago, we would have replaced all of the old nuclear plants with newer designs by now, and nuclear power would be massively safer.
SMRs, because of their small size, at least have the potential to be designed in such a way that the worst-case failure mode would involve someone picking up the failed reactor with a forklift, loading it on a truck, and burying it in cement out in the desert somewhere.
Even with existing nuclear plants, the fear of nuclear power is quite irrational. The number of people killed by nuclear power plants worldwide is about 101, and that includes freak accidents like people getting electrocuted, falling, divers getting sucked into water intakes, drowning, etc. The number killed by actual nuclear-specific risks is just 52, 50 of which were at Chernobyl.
In 1937, the London School natural gas explosion killed 300 people. The San Bruno pipeline explosion killed 8 and put 51 more in the hospital, and destroyed 38 homes and damaged 70 more. In total, 4200 houses get destroyed by natural gas leaks in the U.S. every year. And assuming the odds of dying in a natural-gas-induced fire are similar to other house fires (I couldn't find stats on natural gas fire deaths specifically), that would mean natural gas fires probably kill about 30 people every year.
Yet nobody raises an eyebrow when you tell them that there is a natural gas pipeline running through their neighborhood, despite natural gas fires killing as many people as Chernobyl about every two years.
From a public policy perspective, competent leaders shouldn't bow to irrational fears about nuclear power. Part of a leader's job is to educate the public about why they're making the decisions that they make, and the only way you're going to cure the public's irrational fear of nuclear power is with a multi-decade solid safety record, coupled with education campaigns about how much safer nuclear power is than what's in their neighborhood right now.
I can't see any problems with these huge military and terrorist target all over the place.
What foreign military is realistically going to be stupid enough to attack the U.S.?
Terrorists? Sure, but blowing up a school or a skyscraper would likely cause far more damage and death than blowing up a small nuclear pile, and would be way, way easier to pull off.
I don't know about the security of your nuclear plants, but in my country they are quite strict. And having that security around several thousands more is not feasible.
There's security around major substations already, so adding a small nuclear pile inside those locations might not increase the amount of security needed by nearly as much as you think. There are, of course, a lot of unknowns in that calculation.
Also, bear in mind that pretty much every inch of a traditional nuclear plant represents a potential attack vector. Closing the wrong manual valve or blowing up a bomb that takes out a bunch of coolant lines could potentially be just as catastrophic as blowing up the reactor vessel itself. With small reactor designs, because of the lower thermal output, this is potentially not the case. Having a smaller overall critical attack surface means less need for on-site security, and that is doubly true if you have adequate site design standards to slow down would-be attackers.
Also, what about the fuel and waste problems? Right now one of the major producers of nuclear fuel is our friendly Russia. Yes, the same one that is under a shit-ton of sanctions so they can't sell their oil to fund their imperialistic dreams. You want to turn to them for more fuel? And in other countries with uranium deposits, people are protesting mines. The uranium is low grade in many places with means you have to mine a lot to get enough to enrich. Again, who wants their precious nature to be a huge quarry.
Russia is actually a very minor producer of nuclear fuel. 75% of uranium comes from Kazakhstan, Canada, Australia. and Namibia. Russia (#6 in the world) produces barely a tenth as much as Kazakhstan alone, a third as much as Canada, less than half as much as Namibia, and barely over half as much as Australia (source).
Mind you, this might give Russia more of a reason to invade Kazakstan, but that's kind of orthogonal.
With more reactors we have more waste. Not only spent fuel, but also the construction material when the reactor eventually has to be scapped.
One of the reasons reactors have to be replaced is because they run so hot. Smaller reactors likely don't run as hot, so they may not deteriorate as quickly. This is not a given, of course, and some studies have suggested that some SMR designs may produce larger amounts of neutron-embrittled steel than traditional power plants. So that's a possible concern, but not necessarily a given, and whether it turns out to be a problem may depend in part on how long the power plants last and whether those independent analyses (often done without access to complete documentation) are, in fact, correct.
Also, SMRs can be up to half again more thermally efficient than traditional BWRs, so per unit of energy, you're using less fuel. And they're often designed to use more enriched fuel, which means a higher percentage of the spent fuel is actually depleted, both of which result in less fuel waste per unit of power.
As for the waste problem, my entire life I have heard "we have the solution". Funny enough, it is the same solution now as when I was a kid, decades ago. Just that no-one has implemented it.
We absolutely do have a solution for the waste. What we don't have is the political will to make it happen. Everybody wants the benefits of nuclear power, but nobody wants to pay the price. And until that changes...
Perhaps because no scientist is willing to sign off that the solution will work for 10000 year, let alone 100000 years. Just look at the egyptian hieroglypics, they are not 10000 years old and still we have trouble understanding them.
IMO, that isn't a particularly realistic concern. It's not like the tools that Egyptians used have become unknown to modern science. In 100,000 years, it is safe to assume that humans will still know what a Geiger counter is, even if they have a different name for it. It is also reasonably safe to assume that in much the same way as maps have been kept up to date since the advent of maps, the maps showing locations of dangerous storage sites will also be kept up to date even if civilizations fall and are replaced. There are simply too many people who have reasons to ensure that this knowledge doesn't get lost, unlike the story of some long-forgotten battle or King Tutankhamun's grocery list or whatever a particular set of hieroglyphs happened to be about.
Also, it is worth noting that in spite of millennia of language drift, the more modern, phonetic form of hieroglyphics is readily interpretable by way of Coptic language (which is still in use today, albeit in much the same way that Ecclesiastical Latin is still used).
And at this point, we've pretty much reached a point where a sizable percentage of the planet understands one of a single-digit number of languages, and that is becoming more and more true over time. If you take just the top 5 (English, Mandarin Chinese, Hindi, Spanish, and French), were it not for some amount of overlap, those five languages alone would cover over half the world population. English by itself would be understandable by one in five.
And the rate of language drift is decreasing over time. For example, an average person in Shakespeare's time would probably not have been able to readily understand Beowulf at all, because the differences between Old English (pre-1066) and early modern English are so huge. But today, someone can read Shakespeare with minimal difficulty despite it having been almost as long since his plays were written. From 1066 through the 1300s (Chaucer's era), English and French blended, and the resulting language change was radical. From there to about 1500 or so, the written English language continued to change pretty rapidly. Then it suddenly stopped.
What happened? The Gutenberg printing press. The existence of mass-produced printed writing made language change more slowly, because regional variations that would otherwise lead to language drift were diminished, literacy increased, and access to the printed word increased. As a result, in the 500+ years since, in spite of pronunciation changes, the written vocabulary of English has barely changed at all (though things were often phrased differently back then).
Whether that will still be the case in 100,000 years is another question. We don't even have language from back that far to use as a metric. The oldest cave paintings are less than half that old. But given the rate at which basic English words have stayed constant, barring some sort of large-scale nuclear war, it seems rather likely that written English will still be understandable by a large number of people in 5,000 years or more, and that by then, surely someone will have updated the signs. And in the event of a large-scale nuclear war that wipes out most of human civilization, a small number of deeply buried nuclear waste sites will be a minor risk compared with other radiation risks, so that's probably not an interesting edge case to optimize for.