Mandatory education is still probably better than the alternative but it does seem to create a constant tension: the system has to serve students who want very different things from it

The solution would seem to be a flexible system which identifies and works with the needs of each student.

A school system I attended when I was young divided classes between academic and social --- social classes were attended at one's age level, academic classes were attended at a student's ability levels, I believe that there were also trade school tracks, prompted by students taking Sloyd Woodworking claseses:

https://rainfordrestorations.com/tag/sloyd/