I think it is a matter of perspective. First, many of us wants something (or someone) that would do our work for us. It started with physical work, now it getting to knowledge work. Let's not discuss where that direction leaves us (well... in oblivion obviously), but I have bad news for you in any case. There will be no free lunch. When the bubble bursts we will find out how expensive and vulnerable AI is. Making predictions is not my thing, but most likely we will end up with some Higher Level Programming language. That will address unpredictable AI output, injections, etc. And once again,
non-technical users will have hard time using it. A historical example - SQL, it was originally envisioned as a tool for "non-technical" users. It's already happening. Here is just one example of today:
https://kiro.dev/blog/introducing-kiro/.
And the concept of a "spec" is just one step forward to how gen AI will look like tomorrow. All I can say, enjoy the trial period and try to make the most of it. It will not last long.