Not likely. When manufacturing comes back to the US it's because the company calculated the cost of a US-based automated factory was less than the shipping + tariffs on the foreign-produced goods. If manual labor jobs leave China, they will go to other low-cost countries like Malaysia, Vietnam, etc. or be lost forever. Even producing things in Mexico can cut your labor cost in half in comparison to producing here.
It could mean more US jobs, but it could also mean fewer if you look more broadly.
Say US companies are having PCBs manufactured in China because that's currently the cheapest option. You cut off that option and US companies are forced use more expensive domestic options. The effects of that can ripple through US companies that directly or indirectly depend on PCBs, and the jobs lost throughout the economy could be greater than the jobs gained from the new automated factories.
More importantly it's a strategic positive. Productive capacity is defense capacity. Buying gewgaws, knickknacks, and flipflops from a strategic competitor is one thing, buying defense technology is another, and it's not the path to security.