I doubt the "many, many" part. It's already the case that for parts made in lots greater than a few thousand, "no-hands" automation is cost effective anywhere workers are paid a living wage. Assembly economics lags that, and has been where the low-cost of Asian labor still wins big. But that won't last long. You mention Google and Boston Dynamics, but China's R & D is in a mad rush to fully roboticize their industries.
How small or specialized an "operation" needs to be to be immune is an interesting question, but think about this - the most demanding (of thought, flexibility and adjustability), dexterous, and variable task most assembly workers in this country do each day is get themselves reliably and on time from their home to the factory - and we are within a few years or a decade of being able to custom automate that for ever individual.
The times, they are a changin'.