Local manufacturing initiation support: Isn't tariffs on China, Canada & Mexico beneficial to "us" (US economy)?

As my question suggests, tariffs would undoubtedly boost revenue from imports while also discouraging them. This, in turn, creates a positive opportunity for Americans by encouraging local manufacturing and increasing employment. Stocks are supposed to rally with this news, isn't it?