I executed a major career pivot at age 32 and now that I'm approaching 40, I'm so glad I did. It was hard but worth it. You have plenty of time, as long as you can put aside the feelings that you've waited too long and start looking for a path from your current life to the life you want. Those feelings will only hold you back. Now is a good time to pick a fig and start eating it. :)
It's never too late. I was drowning in debt a few years ago, in a bad career, and I was older than 40 [actual age undisclosed]. I don't have a solid retirement, but I'm now doing well and have some peace in my life.
My one life advice: Don't search for greatness, search for peace.