Earlier quoted context omitted.
My line of thinking on this is “what makes Excel have the combination of simplicity to start and ability/power to scale to fairly complicated workbooks and how to bring that to other fields, including manufacturing?” We could do a lot worse than excel in a lot of areas I think.
Excel VBA and Power Query are regular programming languages. Nothing in particular has been solved by Excel, it's just that the languages that are built in are disdained by software engineers so people assume there's something special about them. It's cultural. You can write a Lisp in VBA if you want. Microsoft's attempt at low/no code appears to be Power Automate, and it's awful (imo).
Excel’s market power is in what you can do in the formulas, interactive exploration, and incremental progress not in the (fairly awful dev-experience) VBA.