Happy atheists in foxholes? I don't think it is incompatible to say that life, inherently, has no meaning - but that life, as we experience it, goes way beyond what we can discover in the sciences including atoms, photons, DNA, cells and so on.
We can certainly give life meaning, as we do all the time, without recourse to religion. But I do think the point is well made that for many people, religion does offer a ray of light in otherwise extremely dark circumstances.
Religion can be used to justify the most rotten of actions, as well as the most enlightened actions. It would be unfair today to say that religion is all bad. But to overlook the harm it does, is also a mistake I think.
The point is not so much that we need to consider the good and bad in religion and stand in the middle, it's to recognize that like almost all human topics, there's a lot to pick out in favor of any specific view one may have.