No, what happens is that US manufacturers buy products from other countries at slightly higher prices, then hike the price of the finished product in the US. Example, and this is real, bicycle gears. Manufacturers of the finished product buy a lot of those from China. Because they are cheaper than Germany.
Boom, with tariffs, German companies are suddenly more competitive. US manufacturers buy from them. Then, to offset their new cost, they increase the prices here. Its not the full amount of the tariff (though it can be). Its often a percentage reflecting the cost from the new supplier.
Trump Wants to Make Your Bike More Expensive
Treated as a zero sum game, the winner is the German company. The losers are the Chinese, the US manufacturer, and the US consumer. The hope is that in the long term the Chinese agree to broader more favorable terms. Not impossible, but history does not typically reflect that the trade war was worth the cost.