Cloud infrastructure is good example of what you are saying. When i started in IT on prem infrastructure was handled by whole departments and people used to have specializations like backup engineer, networking etc. With cloud and infrastructure as a code single devops can handle whole infrastructure part of the project. This didn't kill IT engineers job, instead it create a lot new project opportunities, only folks that weren't willing to change specialization might have problem finding job now.

Same thing will probably happen to coding now and just instead of multiply devs working on project one will be able to handle whole coding side of project as somebody still needs to doublecheck that before it gets pushed to production(in most cases we are handling sensitive user data)

A lot of peoples in the world don't even have refrigerators, there is a lot to do in automation till all of this becomes saturated