The trade-offs with trade are a little more complex than that. For example, if foreign steel was super cheap, you could have the people previously working in steel work in construction, and build more buildings. Or if midwestern auto manufacturing jobs were middle-class due to unions, but the economy shifts to services like Amazon, there is no inherent reason why service jobs couldn’t also be unionized.
In principle it’s not that different from automation - you can think of either as a black box you put money in and get product out. If you are playing your other cards right (admittedly a big if) it would be possible to largely benefit from either.
Traditionally they’ve been worried about inflation but they’ve overestimated that most of the past decade (although it’s jumped up recently in response to the massive short term Covid spending). I don’t think the new stuff being proposed, while large, is nearly as high on a yearly basis so hopefully it can hit a non-inflationary sweet spot (although who knows).