From offices to construction sites, traditional roles are vanishing—but hands-on professions are gaining ground. Could this be the future of work?