I've been in the industry for more than 20 years now, and what's clear to me is that a lot of time is spent coding and debugging things that have been done previously plenty of times (Non Invented Here syndrome) and that in most cases are not core to our companies.
What I expect it's not so much things like Copilot or AlphaCode (that of course will be used) but serverless services that we'd plug into our solution (how many more login services do you want to implement AGAIN?), like we do right now with APIs, but at a higher level, with a standardized communication protocol between these services.
The same will happen the infra level, with only a few people creating and mantaining "low level" solutions while the rest of us will use abstracted services on top of that, like using Cloud Run instead of learning a massive APIs like k8s (I'm not saying that they're comparable right now, but at some point something evolved from Cloud Run will make learning k8s unnecessary)
What will happen once developers are freed from the most time intensive aspects of their job? Probably and for a few years the unmet demand for developers will cover our increase in productivity, but at some point I expect this job will face some of the problems you can see in other sectors.
Personally, I don’t see the train suddenly stopping and going in reverse anytime soon.
It is like all these business systems corparations use. They would probably be better off with some secretaries with typewriters sending internal paper mail.
Systems that try to automate too much are too rigid to use in a sane way.
The nice thing with a no computer system, is that if you want to do something, just do it. An analogue would be writing math notation on paper or on a computer. I can hardly imagine even Knuth prefering the later.
Computers should be used for well defined tasks they are good at with rather simple programs, or the whole business need to adjust to what the computer allows.
The things you listed just don’t matter from the business point of view. They don’t care how the app works, who runs it, what cloud provider is hosting it, what tools were used to build it, only that it works when it needs to and they will happily pay the bill so their employees can focus on making the company money doing what they are good at. Zack Kanter from Stedi talks a lot about this.