Most economists support tariffs in the right use setting. For example, Trump's tariff on Chinese EVs was an excellent idea. So good that Biden not only kept it, but he increased the tariff. That's because the US vehicle manufacturing industry competes with Chinese vehicle manufacturing.
The problem is incorrect use of tariffs. For example, Trump wants to put in a blanket tariff on all imports. Any economist will tell you that this becomes a tax on the consumer. It increases the cost of all products, especially those products that don't have local manufacturing alternatives (like if Australia put a tax on Chinese made EVs). It becomes artificially manufactured inflation. This has been explained to Trump many times, but he's still determined to do it because he thinks he knows more than Economists.