Yeah, I have some related thoughts to this.
Much of the automation happens when you do know explicitly what the goal is. However, for programmers, their job is not turning well-defined steps into valid code but understanding what the goal is from very vague requirements, and that cannot easily be done by a statistics-based ML algorithm.