Gary Mortimer offers his thoughts in this sUAS News article. If you read that news feed daily, the pace of development and field deployment of lower-altitude, aerial and ground robotic anything is incredible. I would think that there will remain some work for highly-skilled multirotor and fixed-wing commercial drone pilots, as long as their equipment and software is compliant with the authorized automatic controls of the nearest airspace, and the Pilot has zero technical options for intruding into that evolving "controlled airspace". Following the money, it's about package pickup, movement, handoffs and delivery involving a combination of robotic and semi-robotic ground and aerial equipment. Zero-occupancy vehicles communicating with each other for handoffs. Distributed charging stations. Minimal fossil-fuel burning. And then there are products like the Volocopter for moving people. Probably a human pilot on board, however most of the time the aircraft would be empowered to take evasive actions in response to unplanned events, because the response time would be faster. Lots of technical and other challenges being worked now, for better or worse. We are still a ways away from something like the dark vision in the movie Oblivion.