I'm 47 years old, I'm a staff data engineer, and the fire in me to solve problems through programming is as strong as ever, and I expect it to last until I retire. I have zero interest in managing people, but I enjoy working with colleagues and teams to solve complex problems (through as simple solutions as possible). I learn something new everyday, and my hunger for learning is insatiable.
Note: I get contacted by recruiters constantly, at least a few times a week. Yes ageism is a thing, but you if you're really good at what you do you're much more valuable than young engineers.