Not sure you've thought this all the way through...
1. Tariffs are taxes. They're paid for by importers here in the US, not the tariffed nation.
2. So manufactured goods importers can eat the tax and/or pass the tax onto consumers. Net effect = inflation or lower profit margins which means lower disposable income and less taxes collected by the government.
3. Should a manufacturer move operations from overseas to the US, now their labor costs are higher - presuming labor is even available. They can eat the higher costs and/or pass the tax onto consumers. Net effect = inflation or lower profit margins which means lower disposable income and less taxes collected by the government. Also if publicly traded, lower stock prices.
4. Tariffed nations will likely impose reciprocal tariffs on our exports. Net effect = our exports cost more, thereby reducing demand, sales and profits resulting in lower disposable income and less taxes collected by the government. Also if publicly traded, lower stock prices.
We live in a global economy. Protectionism and isolationism ignore this fact. The free market has shaped where manufacturing occurs in our world. Trying to overrule free markets, in general, is a self-defeating goal.
And, oh by the way, we've been down this road nearly a century ago. Net result in part = trade wars and The Great Depression.