Between an impressive list of incompatible languages, the vagaries of Git, the complexities of command line access, the reliance on some version of the Unix folder structure - with endless confusion between /etc, /local/etc/, /usr/local/etc and on and on, the weirdnesses of package managers, and completely unfamiliar editors like Emacs and VSCode, the scene might as well be proprietary.
VB at least made if possible to write software in a reasonably accessible and integrated way. So did Hypercard. So does Excel.
The real problem with Automator, AppleScript, etc, is that they're hopelessly underdocumented and the tools are mediocre.
If Apple had made them more prominent and documented them thoroughly they'd have been far more successful - perhaps in an industry-changing way.
But they seem more like side projects that someone spent a lot of time and a little money on. Clearly Apple was never seriously interested in them.