Tariffs are totally a reasonable tool for protecting national security interests or leveling the playing field for the American worker. Unfortunately none of that was done in a coherent or legible way.
With all the global fallout and nothing to show for it I'm really not sure I could have come up with a better way to sabotage the United States.
I could imagine people being on board with it if they could get a tariff funded subsidy for things made in America. If the average person got an explicit discount on their Ford because some rich person paid extra taxes on their Audi, then tariffs wouldn't seem so bad. I just think the actual goal is to make them political suicide for decades.