IMO, the same question could be asked with respect to any abstraction that hides complexity. The answer will always be/has always been: No, it won't. Rather, engineers who can think creatively about the role of pre-built ML models in mainstream applications will be in high demand.
Agreed. That made me think of how statisticians 70 years ago were often good at doing all kinds of tests by hand. Once the doing things by hand part was abstracted away by modern computing they just focused on other parts of statistics.