The fundamental ceiling of what an LLM can do when connected to an IDE is incredible, and orders of magnitude higher than the limits of any no-code / low-code platform conceived thus far. "Democratizing" software - where now the only limits are your imagination, tenacity, and ability to keep the bots aligned with your vision, is allowing incredible things that wouldn't have happened otherwise because you now don't strictly need to learn to program for a programming-involved art project to work out.
Should you learn how to code if you're doing stuff like that? Absolutely. But is it letting people who have no idea about computing dabble their feet in and do extremely impressive stuff for the low cost of $20/month? Also yes.
I don't know what the future of my job holds other than what it always had: helping people who have good ideas to get them done properly.
I can imagine all the people staring at these software projects amazed at the genius it must have taken to create them. :)
Maybe agents and AI in general will help with that. Maybe it will just make the problem worse.
Somehow I doubt that. The monkey is never satisfied.