I agree that we need to keep what you call here mid-skill jobs.
Too often I see people say to the disappearance of manual labor jobs: good, retrain people to use computers. I have slowly come to the belief that there are some people for whom working with their hands is the only kind of sane work they can do.
You can call them blue-collar, or working class (these are the people incidentally that raised me, the people in my neighborhood growing up).
Why would anyone not want to work in a clean office with only a compiler as your boss and a big paycheck waiting for you every two weeks? When I was younger I assumed that anyone not in the tech field were people not smart enough to pass Algebra in high school. It had not occurred to me then that it might go beyond aptitude and instead be due to something more fundamental about a person's nature or character.
I know I'm getting hand-wavy with nature, character but I'm not sure what other words to use. I came to believe that though many people who are like me find some satisfaction from having solved a difficult problem, or having created a functional framework that can now do work to solve problems there are many others where satisfaction primarily comes from having changed something with their hands.
I don't know if all of that makes sense or resonates with anyone. I'll add this though, the older I get, the more I recognize even in myself the satisfaction that comes from doing something physical (even mowing the lawn as an example). I seem to take some pleasure from taking something unordered or in a raw state, and ending up with a thing in an ordered or "finished" state. It's no doubt why I have pursued woodworking as a hobby, print making, creating PCBs. (And that fresh mown lawn looks so much nicer than the ragged lawn that was there before.)
In any event, following that line of reasoning has made me realize we should keep a large number of manufacturing, construction, repair and other manual labor jobs so that we can serve the whole of society. Just expecting everyone to learn to code is misguided and will fail so many people.
It is sad to me that Germany appears to have tried this model, tried to keep manufacturing in their country, and yet it is purportedly failing. I'm not too optimistic about our future when we apparently measure progress by "cost of living standards".