It's not only about fear. We're all trying to make sense of our existences and religions give us a purpose in life that materialism cannot provide.
I think science is actually beginning to scrape the surface and finally trying to look for an answer. It's something that scientists have shied away from in the past, because purpose and meaning sound religious, but IMO one of the end goals of science should be figuring out why and how we came to be.
Based on science and rational thinking we can exclude God (as in the Bible) or Allah (as in the Quran). I'm agnostic, but there are factual errors in both books and especially in the latter it wouldn't make sense as it's the world of Allah himself, who obviously cannot be mistaken about anything as he is Allah. The only logical conclusion is that he cannot exist.