Anyone who can write working spreadsheet macros could probably just learn to actually program. Maybe they aren't going to be making the next RTX Voice or proving P=NP, but I'll bet they could crank out some CRUD
People that are good at using Excel (as in, not just create a table with data, but know how to use it, do macros, pivots, etc), if the need arrives they just move up the chain to Access/Filemaker. I would say Excel is their gateway drug to coding. Maybe now they will move to Honeycode perhaps (if the UI is ok)
The ones that can't use Excel past putting =A1+A2*0.2 can't use most of the no code tools. But they can use a more visual approach to programming. This is the market I believe will/is exploding as more and more, pretty much everything requires a computer/app, but the customisation for each specific case isn't there. They require a more Lego like approach to 'software' development. For me, that is the NO-CODE definition.
Now give the same designer Sketch/Figma, but allow him to sprinkle some logic in ready made blocks (if/elses, loops, save object, etc) and he will get much closer to what he wanted.
Is the second approach better? Well most programmers will scream at the database model, etc. For the designer, he did in 2-3 days what would take him weeks and get away with something better.
I think a lot of programmers look at their experience and think 'no-code' will never work, but (where my experience comes) 20+ years of doing software development as a consultant, what I found is 80-90% of most software share most of their functionality, and the remaining percent are in many ways doable with just a bit of 'scripting'