In other word, no-code coding is going to create more fuckups, not less. Which means more work for programmers, not less. I can guarantee you that big corporates are going to embrace "no code" systems en masse and rewrite their entire current systems using them, which will result in a steaming pile of shit that will bring them so close to bankruptcy that they'll have to hire ordinary programmers to come in and fix, and then the corporate will never use no-code coding again, and it will die.
Hmm, I don't see things quite like that.
I see things closer to the 3d-printing fad. A new tool (3d printers) come out, and manufacturers become hyped for good reason.
However, the internet hype machine gets overloaded, and too many people start to get into the 3d printing hype without understanding its context. This leads to a huge number of people becoming amateur mechanical engineers, and failing at it, for years, trying to get decent 3d printed results.
However, a few people stick with the hobby, become good CAD designers, learn the basics of mechanical engineering, and become true experts with the tool. The rest of the internet hype machine fades into the next fad. The world of mechanical engineering is improved for the better (new tool: 3d printer), there is an influx of new users interested in the field, and win/win for everyone (although a bunch of people wasted their time with the venture).
Mechanical engineers and craftsmen (ie: amateur furniture makers and handimen) really did benefit from 3d printers and 3d scanners. There's also a few weird use cases (orthodontists using a 3d mouth-scanner) that came about that I'm sure no one expected. But for the most part, manufacturers continue to manufacture as they did 10 years ago.
That's how I see this fad playing out. There's probably something useful in the "no-code coding" experience. But we don't really know what it is yet. The hype has to play itself out. Things will probably stay the same (or mostly the same), but some things will change.
----------
Ex: No-code programming might make programming easier. But will it be easier than the "beginner languages" Python / Javascript / Pascal / BASIC / COBOL? Probably not, and people will continue to use the beginner languages in production settings. That's my bet.