Hi OP. My ds is 20 and we always knew he wouldn't be going to uni. He has no SN, but he doesn't have any particular academic bent either. What we told him was that he would have to get a job or an apprenticeship. Apprenticeships were thin on the ground even before Covid, but he is currently working at KFC and has applied to do a vocational course in plumbing next year. Driving is something he will need and he was booked to sit his theory test when lockdown got in the way.
I do actually feel quite positive about his future: he is proving himself to be a conscientious and reliable worker who does what he is supposed to even when it is boring and not very rewarding. That bodes well for the future. Working has been good for him in many ways: he is a far more mature person than he was 2 years ago, and if he gets another chance I am sure he will make the most of it.
As for uni, I'm a lecturer. I see enough youngsters who have no particular bent for academic studies and no particular interest in them either, who are only there because their parents or their school expected them to. They are the ones who end up falling behind, stop going to seminars, and I'd say they make up a good 90% of the ones who get caught in plagiarism and cheating.
My dd was very driven, but her dream was to go to drama school and she had a number of health issues so ended up having to apply 3 years in row. In the meantime she worked at one of the large coffee chains. Again, I think it was very good for her: she learnt all sorts of soft skills that have proved useful since and holding a job down was good for her confidence. She is now about to graduate from drama school but still speaks fondly of her time as a barrista.
What I think we got right was to acknowledge that work can be difficult to find but insist that they had to treat job seeking like a job and keep going until they found one.
After all 50% of the population do not go to uni so it can hardly be a massive failure not to.