Oh OP I know exactly how you feel! I am academically bright and sailed through school and exams etc. Didn't go to uni through choice but took graduate level professional qualification through my employer, back in the days when you could still work your way up. (I also left home and bought a house at 21, on a fairly basic salary - it was doable then).
DH is not academic. He didn't like school, but back then you could still make a good living through hard work. He stayed at home and saved up until we met and married in our 30s, so financially we are very comfortable. He also bought a house but rented it out. I doubt anyone could do the same these days.
Our DC take after him. I struggled when they were young as they weren't interested in reading, whereas I always loved books. They also have no innate curiosity, and weren't interested when I tried to show them interesting (to me) things in the world. They are now teenagers and still fairly middling academically. One has ASD and ADHD and although he tries hard, he just doesn't get stuff. The other probably has ADHD as well, and is dyslexic, but also has little attention to detail and rushes stuff.
Like yours - both my DC are amazing and have so many wonderful skills, I'm so proud of them and wouldn't (ideally) change a thing. But I do worry about their futures.
They are never going to go to uni, and won't get highly paid jobs that way. I do feel sad for missed opportunities, but it is what it is. My biggest concern is that you need a huge salary to get on the housing market these days! However, you can earn more nowadays as a tradesperson than in many other jobs. So maybe an electrician or plumber etc. Although I'm not suggesting those are in any way 'easy' jobs and still require training and qualifications.
But DD at least would love to leave home and do what was possible in the past - live in a city and have fun and rent a place, probably shared, and experience life! I've had to explain that's unlikely to be an option these days - I gather you can't even find a rental let alone afford it. It's so restrictive nowadays.....
(I'm thinking she could maybe do a ski season or tourist guide thing - she's very personable. It's not as though she'd be losing the chance to get on the housing ladder here, and she could have fun while developing all sorts of skills.....)
It's a hard time to be a parent, whatever your children's abilities are. It was just easy back in the day to say 'work hard and you'll be fine'. I assume in 50 years time things will have balanced out - but at the moment, I can't see a good future for many of our kids. Even the bright ones with degrees can't all get decent jobs with a decent salary - it's so depressing.
Sorry - that's all a bit of a moan without being supportive in any way - but I understand where you're coming from...... Let's hope things work out well for our wonderful DC, through some miracle!