I recommend this quasi-review of Rivethead by Ben Hamper if you want a taste of what "manufacturing jobs" were actually like: a lot of people drinking themselves stupid to escape the monotony and utter lack of agency in their work. And this was at one of the Big Three automakers, supposedly the peak of what we're trying to return to! [0]
[0]: https://kontextmaschine.tumblr.com/post/96390732283/happy-la...
In my view, the way forward is, unfortunately, automation. We can't bring that manufacturing back using the same labor basis as is used in Asia. Just to put that labor basis in perspective, we'd be looking at millions of jobs that the military would be funding through sub-contracts. We have to get some of that work done through industrial automation without creating jobs. We need to do that not only to make this sustainable, but really even to make this feasible at all.
I can't help but feel you are romanticizing manufacturing jobs. The vast number of manufacturing jobs that "give people purpose" are still here - those people just travel to china once a quarter.
The guy that stands at a station for 8 hours a day, stamping the same 4 bolts into a car frame does not have anymore "purpose" than a guy running around in an Amazon warehouse.
You think those factory workers have a better job ? Imagine sitting 8 hours a day, just screwing screw.