That's not even considering the issues of planning, permits, installing machines, training workers, etc, in a more down to earth facility like a generic food plant, or heck forbid something seriously regulated (I hope) like making prescription drugs.
That real impact from investment may be 5-10+ years from the initial funding allocation.
Your billion dollar factory can start returning the investment years earlier when you manufacture elsewhere.
It's those last two, impact on the commons and unfair worker treatment, that are examples of where I _would_ support reasonable tariffs. Particularly if funds from those tariffs went to remediating the impact and were agreed to (also observed) by a majority of other leading countries / economic blocks.
It is about manufacturing jobs as identity and social status. Biden would create manufacturing as a "modern factories that create things". These do not employ all that many people and wont revert the world back to idealized past.
Production of critical parts within allied or the same nation is a reasonable goal.
It's probably also more energy efficient to manufacture things closer and ship less.
Now that Trump is president, looks like it's starting to decline again.