It doesn’t really make sense, for example, that we slapped tariffs on Madagascar, when the primary reason we run a trade deficit with them is that they grow vanilla which cannot be grown in the US.
Vanilla will happily grow in parts of Florida and the USVI as well.
Onshore vanilla production, now cheaper than Madagascar given the 47% tariff? No wait; the tariff was reduced to 10%, maybe 15? Something.
The burden of ALL taxes falls on both sides of the transaction. The proportion of the burden varies with market conditions, the most important being elasticity.
That's why studies like the OP are necessary, to determine how much the proportions are. Honestly I am not surprised with the result, tariffs are objectively bad. Curbing trade is bad by default.
That's not what we have here, and that's not what the Trump tarrifs are perceived as internationally.