I think that for modelers, as for many other field of 3d we are going towards a more clearer distinction between CREATIVE and TECHNICIAN artists.
The creative ones create their own design from scratch, maybe even paper and pencil, sametimes they make a clay model to scan, and then they uses softwares as Zbrush to develop and explore the design. For them automation and more powerful software are just another tool to turn faster their ideas in models. There are plenty of example here on CGspciety, modellers who turn their own ideas in models and images.
The technicians instead create their models starting from a blueprint or an existing model following the instructions of same one else.
The tech are the ones that are more affected by automation and by creative designers learning 3d becoming autonomous. But usually designers are more interested in developing their idea then in making a really polished model, so they need a tech to clean it, and usually when a tech scans or copy an existing model, then he has to modify it on request of the client.
I think the pure tech to remain valuable should learn a bit of designer stuff: design, materials, production process,… to became more then just executive, to give more inputs and reviews to the process and pipeline.
It’s the same as growing number of architects learning rendering, but many still need pure renderists because they want to spend more time on the idea or the project. But a renderist who knows interior design, composition, and house building is more independent and valuable.
Or animators, many 2d classical prefer focusing on the main performance, poses and movements, and leave all the technical curves cleaning, constraints, contacts, etc… to a tech. Even mocaps are heavily modified to made them more interesting. And there are still we have creative 3d animators who create performances from scratch on their own.
So my idea is, as long as you are creative and learn new stuff, as an artist or tech you will never extinguish, maybe you will lose just the most tedious and repetitive tasks.