I fear that in the goal of going to "manual coding" to "fully automated coding", we might end up in the middle, where we are "semi manual coding" assisted by AI which needs different software engineer skill.
I do many other things as a software engineer and writing code was always small part of it but time consuming.
Second most time consuming thing are meetings and explaining things to non technical people something like: "No Jerry we cannot just transfer 100GB of data to WebApp in each user browser for faster searching while also having it 'real time' updated".
I'm not learning, just forgetting. Entirely different skills - exercise is important.
In fact I built a tool [1] that applies this principle for semi automated coding. It uses LLMs for generating code, but leave the context selection and code editing for human to complete.
I find this a sweet spot between productivity and quality of output.