If you believe in these tariffs then the major problem is how he enacted them. Businesses want certainty. It takes years to build factories. The next president could just wipe away these tariffs instantly. Hell, even the current one could. That does not give these companies the certainty they need to commit years of effort to building factories. If the goal is to spur domestic manufacturing then, at a minimum, he would get the tariffs enacted via a new law so they're more likely to stick for the long term.
This is the key point. Even if tariffs did everything Trump claims they will (they will not) no one is investing billions to build factories in America for tariffs that will not be there in a few years.
Turns out that governing based on the whims of the executive has downsides.