There is no paradox if what is terrifying for him is the prospect of an afterlife-- or just continued existence. A lot of materialists hold the view that nonexistence is better than (excessively long) existence. (Others want to live forever using technology, of course.)

Does this have anything to do with the "Attraction of Outer Space" in the CosDoc?