Again, the reasons for this are not economic, Trump has stated it is due to Canadian negligence in allowing illegal drugs and specifically fentanyl into the USA, causing many overdose deaths, including that of rock star Prince, a beloved American musician:
By the authority vested in me as President by the Constitution and the laws of the United States of America, including the
www.whitehouse.gov
"Canada has played a central role in these challenges, including by failing to devote sufficient attention and resources or meaningfully coordinate with United States law enforcement partners to effectively stem the tide of illicit drugs.
Drug trafficking organizations (DTOs) are the world’s leading producers of fentanyl, methamphetamine, cocaine, and other illicit drugs, and they cultivate, process, and distribute massive quantities of narcotics that fuel addiction and violence in communities across the United States. These DTOs often collaborate with transnational cartels to smuggle illicit drugs into the United States, utilizing clandestine airstrips, maritime routes, and overland corridors."
What Trump wants is better policing of the borders so the flood of these drugs into the USA is stopped. He wants Canada to play ball with US federal law enforcement and is using the tariffs to induce cooperation that was not obtained by asking Canada, nicely, to play ball. As soon as Canada starts to cooperate as they have been asked, the tariffs will be reduced or eliminated.
This is absolutely no different than the neighbor who lives next door and continually lets his dog take shits in your yard. You ask him nicely not to let the dog shit in your yard. He doesn't stop. At that point you send him a bill for the clean up costs so he can pay for the damage.