How can I turn my life around? 30M

I am massively struggling in life having hit 30 and deciding to leave a career that I hated (sales, 5+ years).

Never had a job I enjoyed (sales, marketing, bar work, copywriting, marketing degree at uni), I've always had to force myself to do the work which led to burnout and resentment for the job.

Not had much success dating, one girlfriend my whole life that lasted less than a year, and depression/difficulty socialising for most of my adult life. I've been having therapy, it helps a little, but my major problems haven't gone away, I'm possible inattentive ADHD.

Good things.. Physically I keep myself in okay shape with weights and cardio. I have some good friends and family who are supportive but they can't solve my problems for me (I wouldn't expect them to). I feel like I'm a good person, trustworthy, dependable, kind, generous, but it's not getting me anywhere.

Big 5 personality traits (I feel this is an awful combination): Low conscientiousness, low extraversion, high neuroticism, slightly high agreeableness, average openness. IQ above average.

I need a career that I enjoy and can commit to, but I feel like my low conscientiousness/extraversion holds me back massively, and so many jobs sound under threat of AI I'm worried about committing to retraining in something else then the job being taken away, or I don't enjoy it.

I'm interested in photography, food, psychology (considered training to be a therapist but it's a long and costly road of training in the UK), music, travel, sports.

If anyone has any advice, I would be so, so grateful.

I feel like my 20's were wasted and life is slipping away from me.

I'm not materialistic, and don't want the world. I want a decent paying job that I genuinely enjoy/is meaningful, to enjoy time with friends and family, a loving intimate relationship, a little bit of money to enjoy some hobbies/travel, and to not feel so depressed all the time. Things that most people would want.

Thank you, appreciate any ideas or advice.