The science fiction is scary but jobs that require a physical presence, including the trades, are likely to prosper in the new labour world