Oppenheimer sees artificial intelligence driving a "blue-collar renaissance" as automation threatens to replace office jobs and boost physical trades.