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.
I am quite sure that plenty of Excel users know BASIC and SQL.
I would love having the capability of just writing json-esque SQL that has the most basic type checks, alas we live in purgatory with weird build systems to validate queries.
I'm not sure "normies" is the right grouping. I think that is too broad some people are artists and some people just aren't that curious to try. I think a better group to target is "makers" I think that's anyone with enough ambition to at least try and fix a plug or change a lightbulb.