I hear you. I'm 48 and I'm a similar position.
I don't think spending a lifetime in a role which is a long way removed from your own nature and inclinations is quite the solution either though. Sounds miserable.
I think the best life you can have is to have:
Some degree of control over your working day doing tasks that your nature lends itself to.
Enough money to pay your bills (more is better, but at least not be failing to make ends meet)
Colleagues who are decent humans even if you're different people
Work that you find rewarding or interesting in some way.
Looking back on my work choices, I can see that I made the best decisions I could with the information I had available at the time, and though I don't think I've found the sweet spot of something I enjoy that pays very well, I have had an interesting time in various ways, have quite an average life (but so do most people - clue in the name 😁). I've never struggled to find work, so financially I have my head above water but I'll never be rich.
Things I wish could have been different...
I had zero guidance from my parents, they were utterly clueless and we were in poverty as I grew up, so uni represented 'very scary debt' (bearing in mind money troubles -like not enough to eat make you risk averse) and I had no idea what doors it might open.
I thought I was much less able than other people (I was a neglected child, so self esteem crap) so didn't realise until much later that being well paid was an option for me... Turns out I'm no less capable than anyone else.
I am wistful about my wasted potential, but try to accept that my life has not been a waste in other ways, use my experiences to help my kids understand better than I did and try to make the most of where I am now.
I have some friends who are very well paid, they don't have charmed lives and there are positive things about my life they don't have and vice versa... So in the end your have to try not to let regret spoil your outlook and keep your life about being secure, who you share it with and remember you are more than your job.