Wikipedia has a whole list of citations on this very sentence lol.

There is near unanimous consensus among economists that tariffs are self-defeating and have a negative effect on economic growth and economic welfare

https://en.m.wikipedia.org/wiki/Tariff

Tariffs are a net negative. Always. The things produced will not be competitive on the global market, if they were, we’d already be making them. The higher prices always destroy more jobs than they create. Retaliatory tariffs destroy even more jobs. The higher prices drive down demand and make the working class consumer poorer. Always.

There’s no economic upside to tariffs, over any time horizon. They create a small number of jobs in a specific sector at a very expensive cost. Some politicians might decide that the enormous economic cost is worth it for other reasons, but a net positive they are not.