I think Streamlit is great for making apps for non-technical users; it’s one of the fastest ways to go from script (that only someone with coding knowledge can interpret / use) to web app (which almost anyone can use). I’ve personally built a few apps for non-technical people myself (e.g., AutoAR). It’s quite straightforward to self-host rather than using the community cloud (as @awaisalimir mentioned), so it should be feasible to have internal-only Streamlit apps.
I think a lot of applications perform simple CRUD operations and Streamlit would work great for those; in fact, there are quite a few other companies that try to cater to this (e.g., Retool, Windmill). That being said, there’s still a pretty big gap between a one-page web app and fully fledged applications suitable for use across massive enterprise systems (i.e., with account provisioning, integrations with other systems, etc) and I’m not sure whether Streamlit intends to tackle those topics in the near future