Even if tariffs made it so that making goods in the USA was more financially viable, it takes time and capital to ramp up a factory. It takes a ton of overhead to bring that factory on line, like hiring and training the workforce. Plus, the supply chain for many finished goods now stretch across the entire world, so many of the inputs of whatever the factory is making also come from tariffed regions (steel, aluminum, semiconductors, plastic resin, etc) . Also, the USA has relatively high labor costs, relatively strong environmental protections, and very long permitting and construction processes.
Combine those factors with the near daily changes in proposals and enactment and it means that businesses would rather eat some years of tariffs right now rather than move production to the US. Who's to say that the cost distortion caused by tariffs will persist long than a week, a months, a year?
That's not to mention the inherent inflationary nature of import tariffs, plus the probable loss of export business to retaliatory tariffs imposed by other countries. Neither of which will help the US economy IMO.