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.