Years back I came up with answers for those questions that work for me where it doesn't require for religion or afterlife and still makes me want to wake up the next day, YMMV. Also, I'm not religious, don't believe in after life, in spirits/souls and don't have children, yet I think I have a pretty happy and content life and almost never am affected by bouts of long term sadness/depression.
> If there is no afterlife, then what IS the point of this life?
First of all, think about the question itself. Why does this (and our existence in it) require a "point" to existence itself or a "purpose". Both of those concepts are human level concepts, they have no meaning to the universe. It's like asking "why isn't life fair" or "why isn't life rewarding good people", all those (fair and good) are human concepts that the universe cares not for. We are naked monkeys living on a tiny blue planet in a huge universe, to expect reality to conform to our evolved concepts of modeling the world is ultimate hubris.
Once I realized this I stopped asking the question. There is no "purpose of life" because the question itself is silly/absurd. Then the next question is, does it matter that there is no purpose?
I looked back at everything that brings joy to me in my day to day life and none of those things relate to life having a purpose or not. I am happy because I exercise and makes me feel good after it or makes me feel fit and healthy. I am happy because I live with someone I love (15+ years and going) and they love me and we share our existence, we enjoy time together, develop internal jokes, help each other (which in turn makes one feel good), comfort each other. I am happy because I have a satisfying job, smart coworkers, interesting projects and I'm well payed and can afford a good life. I am happy because I am still healthy and don't have to think about mortality every second or deal with pain or are afraid of the future.
I realize that makes me a very lucky person, but I also realize that none of the things above have anything to do with "purpose" in life or anything like that. Nor do those things exclude having kids, on the contrary, I imagine having kids would bring even more personal satisfaction and possibilities to be happy about. Having friends/developing relationships makes us feel good, we are evolved to be social beings, so that's why we do it, not because there's a purpose to life.
Hope this helps