After more than two decades in the industry, you start getting cynical towards these kind of "programming for non-programmers" tools. All of them are trying to abstract away the complex parts of the programming problem. Guess what, it doesn't matter how many layers of abstraction you pile up, you never abstract away the need for consistent logic. You end up requiring the same kind of people that have the brain skills…
You're right, but you're also looking at it from the lens of a programmer.
From a user's perspective, they have a problem to solve, and they just want a tool that will help them. From their perspective, they are not thinking about it like a programming problem. Even if they have to write a little bit of script/code, they don't necessarily perceive what they're doing as programming.
That's why Filemaker Pro, Hypercard, Excel, Notes, etc. developed huge popularity among "advanced end users".