I've messed up retraining. What can I start instead at 50?

[asmallcountry]

I need help with ideas for retraining because I've spent the last 8 years trying to find a new career/decent work. I've recently retrained and it's not working out - and I can't keep getting this wrong.
I had a career in a very niche, very visual, field in London for many years. I wasn't wildly ambitious with it, but it was ticking over. Then I relocated (for DH's work) to a different area of the country, where this particular industry and career doesn't exist. It coincided with the end of my maternity leave for my 2nd child and it was a very overwhelming period, moving to an area where we didn't know anyone, trying to put down roots and my DH working 60 hours a week in a demanding job. So I decided to take a couple of years to focus on being a SAHM, do lots of work that needed doing on the house, and then try and get back into the workplace.
Well. Getting back into the workplace was so much harder than I thought. It was really hard to find anything to fit around DH's long hours. I had a few part-time jobs in the arts and admin. I finally found a full-time wfh entry-level job, which worked ok for a year, but the boredom of an entry-level role and lack of progression opportunities made me decide I needed to retrain and get some actual qualifications, a higher-paying job, and better long-term prospects. I retrained on one of the government-funded tech bootcamps. Not because I was interested in, or showed particular competence, in tech, I just wanted to find something "sensible", in demand and with prospects. The course providers assured us that it was suitable for everyone, even those with no prior tech experience. It did seem successful to begin with, in that I got a job afterwards at a much better salary (not wildly high, but it's around the average salary for my age and it represented only the second time in a decade I'd had a year earning in five figures and the first time in a decade I'd earned more than £25k in a year - so it made a massive difference to our family finances and my almost non-existent pension pot).
However, I'm rubbish at it and I hate it. I'm scared all the time that I'm going to get found out. My work is stacking up and I'm falling behind. It turns out that no matter how much I try and cram into my head I can't grasp enough of tech to be any good at this. I know I can't stick it out long-term, as I've realised how fast you have to be to keep up with all the changes in the field, and at 50 I can feel my brain isn't as good as it was (and I'm struggling to keep up with colleagues).
So, what to do? I look like someone who can't stick with anything, but aside from my first career, I haven't found anything I feel good at.
I've been wracking my brains for what I can try and do and I'm feeling so stuck and hopeless - I'm just posting in case anyone can suggest anything I haven't thought of.
Essentially, I need something that doesn't require a huge amount of retraining (can't afford an MA, for instance) or where retraining can be done on the job (I'd be open to an apprenticeship).
I'm considering what I'm good at (and bad at). I'm much more aware of myself than I used to be, especially now that I have a later-life diagnosis of ADHD and autism - which has made sense of so many things I've struggled with in life and in work. This is my summary:
-I'm creative, and very visual, but I know I'm going to struggle to keep up with tech in modern creative fields like design - I feel that there are so many younger people coming through who have such solid skills in these areas.
-Most people think I'm good with people - I'm welcoming, and appear good at social interactions. However, I'm masking well - which I find quite exhausting, so some "people" jobs might work for me, but others might get overwhelming.
-I find admin almost unbearable and impossible and I get overwhelmed and bored to the point of inertia. (I think this is the ADHD).
-Variety is good. Some movement is good. I'm good at fine detail and intricate work with my hands. I would have been great in an age where I could have sat on a production line in the potteries painting intricate decorations on pots. I'm good at light manual work, in another life I could have been a gardener or done painting and decorating - but I'm not young enough or strong enough now.
I have a medical condition which means that although I can drive I find it very tiring and quite difficult - otherwise some kind of delivery round job might have ticked the boxes in terms of variety and movement.
I feel that if I had my time again and was doing a degree again I'd have picked something like art conservation or art therapy.
Essentially, I need a change, I don't think I can do admin or office work, but I'm not fit and young and strong either.
Any ideas?!? Help!

Is there a way to make your current career easier (at least in the short term)? Have you asked for any accommodations? Applied for access to work? Maybe there's a neurodiversity network in your field? If you're in a larger organisation is there any work shadowing available? I was thinking if UX as a PP suggested, it would be so good to find something you like where your tech experience formed a relevant back drop.

I really appreciate these replies, especially @Floopani - it's good to hear from someone else in the same boat. I really hoped tech would work for me, because I enjoyed the training, but what you've said about finding it easy to learn new things but then getting bored/puzzled by the practical application resonates so much - that's me exactly! @Floopani How are you retraining as a therapist - what path are you taking and what specific course/certifications? How long will it take you? I've considered training in a counselling-type role before but got daunted about the time and expense before being able to earn. Good luck with your therapy and craft endeavours.
@renomeno thanks for these links. I search on the Heritage Crafts website every now and then, especially the at-risk crafts, in the hope I'll find some kind of opportunity to become an apprentice or train. The coaching site looks really interesting.

@Lbdse interesting one, checks lots of boxes for me, although I've always been a bit squeamish about feet, so I think that might rule me out 😄. I have considered before that I might find medical pathways like being an optometrist or radiographer interesting and a potential fit, but I think the training routes would be way too long at this point.

Nursery nurse you are on the floor all the time plays havoc with your knees not a got job for older ppl ,,,it’s for the young

@DrawersOnTheDoors, thanks for this wise post, yes I'm just starting a conversation with my employer about what might be helpful for me in my current workplace. (Although I feel that nothing less than a brain transplant will really do it!)

For transparency, I worked as a mental health nurse for many years, left nursing for the usual reasons and went into tech, missed working in mental health so have gone back to it by training as a counselling alongside still working in tech. It's bloody hard work alongside a full time job and will have cost about 10k by the end of my training with no guarantee of employment at the end of four years. I'm a year away from qualifying as an integrative counsellor with an advanced diploma and then I'll likely go on to a masters, and my previous experience in mental health has been so helpful. I truly love it and feel I have found my calling, which mental health nursing nearly was but not quite. Tech is definitely not, but without having been in tech and paid what I am, I probably wouldn't have been able to afford to train in counselling.

Good luck!

Just thought I'd add my experience here, or at least the career paths I've taken. I did an art degree, then a PGCE and was an art teacher, then did a PGDip in Art Therapy as was an Art Therapist. I both gave up work and moved out of London when DC were small. When I looked at art therapy job possibilities when DC were a bit older funding had been reduced all over and there was basically nothing in my local area. Eventually I did a MSc in Computing and now work as a web developer. I really like the problem solving aspect of it, am really happy in this career and actually prefer it to my previous careers, which I found interesting but also emotionally very draining, which web development isn't.

Netcam, that’s really interesting, I have been wondering about doing an MSc in computing, maths was my strong point at school, but I’m worried I’d be too old to get work in that field, approaching 50…what do you think? Also, are you working remotely?

I did my MSc in my mid 40s, but did part time freelance work after that for about 7 years. I got my first full time job recently, I'm now early 50s. I work mainly remotely but have been going in one day a week. Most of my colleagues are about half my age, but it's a great, friendly atmosphere with interesting work and I love it so far.

I wonder if thinking laterally about your tech experience might open some good doors for you: someone else mentioned UX and that and aligned job roles would fit a lot although not all of your boxes: user researcher (very people focused, understanding how people do stuff now and therefore how tech could fit; testing possible tech solutions); interaction and content design (designing the interface Ito the look and language; IxD is highly visual but also about understanding how people interact with tech); maybe even service design (end to end process) or business analyst (helping the business side think about how the tech needs to work for them; process mapping). Or something more people focused like scrum master? (Tbf can be quite admin heavy, but essentially helping a multi disciplinary team work well, some tech understanding helpful (more Ito understanding agile, which is easily learnt). Gov/local gov as well as private sector have a lot of entry level/apprenticeship roles in all of those, they are tech aligned but don’t require much if any true tech interest or skill, and gov/local gov at least will be very open to older joiners (I moved into one of those roles approaching 50, and have moved up very rapidly.

I can dig out some links if you’re interested in any of those :-)