That much is clear.
This can kind of be the case with narrow, directed tariffs (protectionism of a vulnerable uncompetitive industry, for instance see https://en.wikipedia.org/wiki/Chicken_tax), or in a developing country that has mostly primary industry (that is extractive industry, mining and that sort of thing). In a developed country, it’s a lot more complicated; a lot of that manufacturing probably depends on imported materials or parts (so tariffs hurt it from that direction) and a lot of the market is probably export (which tariffs also hit, for tariffs more or less inevitably lead to retaliatory tariffs).
And where you have heavy protectionism, the _consumer_ tends to suffer, as the protected industries have little incentive to make their products good or cheap. See British Leyland; for quite a while the British government attempted to keep it alive by heavily restricting the import of actually good cars. Spoiler: it did not work.
Say we put a tariff on socks. And Hanes opens a sock factory in the US. Is a few hundred sock jobs going to help the millions who aren’t making socks? Does working in the sock factory pay enough to buy computers and cars and other higher margin goods?
Generally speaking, for broad tariffs, the answer is “No”.
All more expensive than importing but supports local economies. Again, I'm not an economist, and tariffs are not a panacea, but they are also not useless.
Might not turn out to be as self-sacrificing as I thought.
How is your mental model literally backwards from reality?
Not sure about musk's wealth but TSLA is down by >30% in the last 3 months.