The problem with tariffs is really just trumps complete instability. Why would anyone invest in domestic manufactoring when Trump wildly flip flops on all tariff policy using it as a diplomatic punishment and reward system? Especially when his tariffs in general are legally questionable at best and the other half of us politics are against them just in principal. Imagine investing millions in a domestic factory and then trump gets a personalized jet from some random nation so the tariffs you were depending on for your profit margin are gone. Or Trump loses the midterms and now tariffs as a policy are gone. Unless Trump both becomes a dictator and sets the tariffs in stone without changing them too much, or democrats come out in wide support of tariffs themselves, I don't see how you could use them to invest your money.
Also, anything companies build inside the US (factories, supply lines, etc.) just becomes an economic hostage for a Trump to use for further rounds of extortion.
So it's not just that the policies are (A) counterproductive and foolish and (B) changed on a whim and (C) have no long-term foundation and (D) are changed for corrupt reasons... but even after all that, (E) the corrupt person "making deals" is incapable of honoring them.