If you charge Canada a 25% tariff then products sold in the U.S. and shipped from Canada should cost U.S. consumers about 25% more. That, in turn, makes U.S. products look more attractive. A U.S. business pays taxes at the federal and state levels. A U.S. business also hires U.S. employees, who pay taxes as well and spend into the economy.
I’m sure I’m way over simplifying this, to the point of stupidity, but tariffs raise prices on foreign goods to encourage the sale and/or development of local goods, don’t they?