Yes, I totally see your points and I agree that needs to more softwares.
We should take game industry as an inspiration. Many games have mods and modular design. Minecraft is the best example. Without coding, players can create interesting new things from existing rules.
However, functionality software is not like this at large. To extend a functionality software, one has to code. Examples are:
Small nostr clients, VS code extensions
Worse, centralized platform software does not even allow you to extend with code.
Therefore, to address this problem, having more programmers is not the key. To have more no-code, extendable software is the key.
When users find composing with existing modules (minecraft building blocks) not enough, they will have a reason to learn the code.