I have a similar background, and I largely agree.
What's dying is the programmer-first job. That guy whose main use is that he knows how computers work, and secondly that he is a human who can understand how some business works, and can do the translation.
The other type of programmer is the business programmer. I started on this end before an incredibly long rabbit hole swallowed up my life. This is the person who thinks he's a finance guy, or an academic, or an accountant, or any number of things, who realizes that he can get a computer to help him.
This type of person is grounded in the specific business they come from, and has business-level abstractions for what he wants the computer to do.
AI is still imperfect, so it is still in your interest to know how the computer works, especially as you dive into things where your model of the machine actually matters. But it allows the person with the business view to generate code that would previously be their second job. He can QA the code on a business level. This used to just be called Excel, which would generate horrors for anyone who could actually program, but it is still the glue behind a huge number of business systems, and it still works because ugly often works.
I liken this to previous revolutions in IT. At one point schools had begun churning out literate people, and they started spilling out into the business world as clerks. You could learn how to read and write, and that would get you a job sending correspondence to India, that sort of thing. And that would be your way into the organization, and maybe you'd eventually learn the business itself.
People who typed stuff had a similar fate. There used to be rooms of people who would type letters and send them. Now the executive just types the letters and sends them off by email.
If you're a translator first, AI is not great for you. If you managed to turn your translation skills into executive skills, then you are happy to pull the ladder up.