There is an embedded assumption in the question that he does profit in some way from it, but based on his past behavior it’s a pretty safe guess.
Most of the reporting I have seen on this talks about the impact of the different tariffs, but not the “why” behind it (beyond parroting what Trump says, which is never true). I’m particularly interested in the tariffs on Canadian goods and energy. The justification about stopping fentanyl smuggling is an obvious lie. (It isn’t a real problem, and tariffs have nothing to do with drug smuggling. All but the mentally handicapped can figure that out for themselves.)
General consensus is that he is ego driven. He wants to be seen as someone who gets good deals, he even wrote a book on it, and he was talking about tariffs during the election. Either he gets a good deal negotiated with Canada or he fulfills campaign promises. I don’t think he cares which.