While a bit reductionist, it's pretty much right. Tariffs can work if, and only if, the market believes the tariffs will last long enough to spin up entire industries, and then recoup that investment.
The problem with Trump's tariffs is that everyone knows they are relatively short term. At most, they'll last until the end of Trump's presidency, and even that's assuming that they don't get struck down by the courts, or Trump flip-flops on them like he does everything else.
Without the ability to credibly ensure their ongoing existence, tariffs fail their only real purpose of incentivizing domestic manufacturing, instead acting as a regressive tax on your population.