I do think that Trump is irrationally attached to protectionism, but I also think that tariffs have at least 2 concrete benefits for him: 1) as a tool of economic coercion to achieve geopolitical ends, and 2) as a form of corruption to solicit de facto bribes in exchange for exemptions.
2, yes. 1, maybe he thought that would work, but it hasn't.