You need such things for national security, so it's very likely "worth it" even all the way down to the American consumer level.
Look at the shipbuilding industry if you want to see what happens to that capacity without it. Due to the lack of commercial shipbuilding in the US, we can't even keep up with building for our Navy during peacetime. If a war ever were to attrit naval forces to any meaningful degree there would be zero hope of scaling up that supply chain in a relevant timeframe.
Arguments could of course be made if the auto manufacturing industry (and it's suppliers) are useful in an actual hot war, but I think without them we'd be in even heavier dire straights in that regard.
This does not mean there is zero hope of scaling up should wartime demand come into existence.
Although U.S. shipbuilding is greatly diminished today, it is not the national security concern many would lead us to believe. America’s rapid expansion of ship production during World War II serves as a reminder of what allowed America to increase its ship production historically. Orders surged from the US government and other allied nations for commercial ships. Companies converted capital and entered the ship building business to meet the orders; Henry Kaiser built a shipyard in Richmond and got it operational in 78 days.
Currently the demand for US military shipping is low, some suggest a change in organisational structure and siloing might be a path forward: The Next Great Era in U.S. Shipbuilding https://www.usni.org/magazines/proceedings/2025/february/nex...
The large American manufacturers are able to keep on selling technologically outdated, overpriced vehicles in the US, because they have a captive market.
When the Chinese imposed protectionist measures in the auto industry, they were aimed at allowing Chinese domestic manufacturers time to catch up technologically, and they were scaled back as that happened. Any international car manufacturer can now set up shop in China and compete directly with the local brands on an even footing. But the US has imposed drastic protectionist measures with no end-game (worse than that: US policy is backwards-looking and intended to maintain an old technology). It's just a permanent state of affairs.
Ultimately, this sort of protectionism tends to be expensive, and yield an inferior product.
We could also do this without tariffs by simply taking money from some group and handing it to another.
https://en.wikipedia.org/wiki/History_of_tariffs_in_the_Unit...
So as usual, tariffs cost the country imposing them, returning less net goods, and moves money into the protected class at the expense of the wider public.
It creates different incentives for the receiver.