I've come to see such questions in terms of what is lost and what is gained.
We build our lives on something rather than nothing.
We have relationships built on something rather than nothing.
We live in societies built on something rather than nothing.
All these foundations and all these networks rest on solid ground. But, solid ground may not be the best of all possible grounds.
On a faultline, even the most majestic cities can topple from a sudden jolt.
So too with human belief.
When we are Atheist we are a jolt. We shift at the faultline. We topple cities and ruin societies and split families into shards of despair.
Why?
What do we offer when we remove so much?
I'll give you a rather desperate analogy.
Japan.
Japan before WWII was a society. It was a feudal society of peasants and overlords. The emperor was god.
Two atomic bombs fell upon Japan. When the fallout settled there was the cataclysm of not only infrastructure, superstructure and political destruction to deal with. God was deposed! The entire basis of the feudal system was not even possible.
An American general, Douglas MacArthur entered the microcosm. Everything rebooted from rubble.
Today Japan is not feudal. It has a kind of inevitable prosperity, freedom and opulence which brings opportunities for good and bad which were entirely impossible before the bombs fell on Hiroshima and Nagasaki.
Is the Japanese society today with its prosperity, freedom, productivity and technology a vastly better society to live in for young and old than the feudal overlord and the peasant who kow towed to the Emperor?
You cannot have Japan today without the total destructive cataclysm of the Atomic Bombs.
Such is the sort of diabolical set of alternatives one faces (admitedly on a much smaller scale) when one contemplates destroying the foundation of God and the feudal social system of religion.
Think about it.
Some people cannot/won't make it through to the prosperity and freedom.
Should the bomb of Atheism be dropped always or never or only sometimes?