I was raised Catholic, not hardcore Catholic or anything, but Catholic.
So like all religions, I was told that my existence/life, just by virtue of existing, ultimately had a higher purpose/meaning.
As I got older, especially high-school and after, I increasingly became agnostic (An agnostic theist to be specific) and eventually stopped identifying as Christian all-together. And now, these last few years, I've been transitioning from that to full-on atheism.
I'm not 100% there though, and I'm not sure I ever will be. Because no matter how hard I try, there's this part of me that simply can't/won't fully accept the possibility that my existence/life really and truly is pointless, even though I know that's the most likely scenario.
It's like being given the softest, warmest blanket you've ever felt in your life, the idea that you're here for a reason and that after it's over you'll get to see and be with all the people you've loved and lost in your life forever...
...and then having it ripped from you and thrown outside into a blizzard, that it was all a lie.
And no matter what I've been told by others to try and replace that blanket, whether it's been stuff like "You give your life meaning." or "Just have fun while you're here.", none of it has actually made me feel better, no matter how hard I try.
It's like some Lovecraft shit: I've seen the horrible truth, but my mind simply cannot fully comprehend/accept it, and thus I'm slowly going mad from the revelation.
If I had been raised atheist from birth, I think I'd be handling all this better. It's the fact that I once believed existence/life had an ultimate meaning, and had that taken away from me, that's creating this conflict.
If I had never been given that blanket and known it's warmth, and was instead just born into the blizzard, I'd be better off right now.
it isn't pointless, it's just the task is de-motivatingly vast, especially from an individualistic perspective. which is why we have the comrade stuff.
we need to solve a lot of issues with our planet & societies. Why? because we need to understand existence, in order to determine if there is a point or not.
to understand existence, given our material constraints, we need time - a lot of it, and people, a lot of them. and also technology, because our biological bodies aren't enough on their own.
so we need to solve the issues that take away from our time, and from our resource of people (or in a detached way, having multiple brains working on the problem).
therefore the goals currently, the purpose of our existence is to ensure the survival of the species, & ensure the survival and optimal function of each individual of the species.
given again what we've worked out so far, I think this means we need to find out how to either live forever or learn faster in a lifetime, and also we need to get into space and colonise other parts of it, to be safe.
but capitalism, aristocracy, etc are inimical to species survival and progress toward understanding so we need to revolutionise the world & get rid of them, implement a better way or multiple better ways.
in conclusion there is a definite material point to existence currently, deducable from what we know currently about the world (including that there probably isn't a god at least in the way that most religions mean it). There is a grand task that we should all be working on together as a species, in a number of ways and means. Unfortunately we are burdened by parasites.
edit:
i'd add also that religion isn't just a comfort blanket, that's just a useful outcome of religious thought. there are many truths in theologies, and they're part of how we got to what we know now
maybe look into other religions other than the one you were brought up with, it can be easier to see the truths and ideas in them from a distant/unfamilair perspective, rather than the flaws and sins that you tend to see after being lied to. not to say that some other religion is necessarily correct, but for example buddhism isn't particularly comforting I wouldnt' say, yet many people believe/follow it.