Except a person will still continue to purchase the cheaper option in most cases -- So you're not really hurting the Producer in Mexico at all. As long as their product is still cheaper even with the tariff than the same item made in the US the cost is shifted right onto the consumer.
You would have to create the same products in the US or import from another country cheaper than what is done in Mexico for this to damage the producer in any meaningful way for it to have the effect you're talking about.