It's not really a profound insight. Back in the 1980s when I first started writing BASIC programs I remember thinking "well, if someone invents a program that can write programs, there will be no more work for programmers"

It's easy to have that thought, and eventually you'll be correct. One thing about technology is that it only improves. It's always building on top of what already exists. The only uncertainty is the exact timing, not the ultimate outcome.