It is to be seen. Capitalists are the closest thing we have to rational economic agents. If there is a buck to be made in American manufacturing then that buck will be made.
My layman concern though is that these tariffs are not going to be stable enough to convince daddy warbucks to build a $10m factory.