That's my experience as well. Some folks like to dabble, but for the most part they have other stuff they want to focus on, they don't want to spend the time to ensure it's good and it works.
I'm not saying an agent couldn't make sure it's good and it works, but there are a lot of aspects to that: It's compliant, it's secure, the right data is stored, the right compromises are made for sometimes mutually exclusive business priorities, UX is decent, it's responsive, it scales, hosting is economical, it has the right tests, monitoring for the right risks, and so on and so forth. A lot of devil in the details, and the context required to know what to focus on is rather vast.
If anything, I see this work getting harder, since the discipline around minimal scope is getting weaker, leading to a complexity explosion affecting all of these aspects.
It usually comes down to how successful a business is. Just starting out with little to no funding? They'll want to dabble themselves. But if there's money, it can and will be exchanged for time. Easier prototypes and MVPs means faster business model validation, which means higher willingness to invest. I do see this happening.
Will we always need to know programming languages for doing this? Maybe not, but it doesn't matter. If you make a machine do stuff for a living, you're a programmer. How exactly you do it doesn't affect that in my mind.