You hit the nail on the head. A lot of people are just scared by the chaos and meaninglessness of life and death. It is terrifying to know that everyone you know and love is going to die and be forgotten, eventually, including yourself. Everything that has meaning to you has an expiration date, and a lot of people have trouble accepting that. So they hold on to illogical fairy tales of eternal life in paradise to deal with the existential dread.