Your three examples historically were successful in achieving widespread usage, and in the case of SQL, shows no sign of disappearing.
SQL is a real programming language with a super high ceiling if you need to write scalable queries.
I think this is a point I should make more clearly. And there are more examples of programmable environments. Excel being one.
They are widespread, but not among "normies", but professional programmers. That's what I call a failure, since they were initially designed to be used by non-programmers.