I felt this as someone who grew up religious.
It was until this year that I properly internalized that the universe does not give a shit whether “human race survives”, or Earth survives. Or anything survives. Heat death of universe is slow but inevitable. The universe is merely a bunch of elementary particles interacting with each other via force fields. It has no ulterior motive.
All Gods are human made Gods to give us meaning.
However as a human, our experience and feelings is the ultimate personal truth. We are the hero of our own story. We have some other characters and everyone else is a NPC.
We are here because our parents survived to have us, and their parents to have our parents and ongoing for millions of generations.
Nature selects those who survive to reproduce. Human desire has been shaped by evolution. Anyone not passing on their genes, has their gene-line terminated. Those that remain preserve certain behaviors.
If there is some eternal meaning - it is selection. To survive, procreate and proliferate until the heat death of universe.
We were not built to enjoy. We were built to be paranoid and feel we can do more, be more, have more. In the hope it leads to better survival.
However dopamine - the reward molecule can be hacked.Orgasms give the highest natural release. Now most of humanity gets dopamine kicks from Porn, social media, sugar, fast food, drugs.
We are dopamine driven beings.