The most popular app is Roblox. It has 164 reviews. The second most popular app is Spotify. It has 57 reviews. On Android, it has 19 million reviews. Their Android TV app even has 200. The item with the most reviews is Minecraft, with 1000 reviews. On Android it has 3.5 million.
The author of krita mentioned in this thread that their revenue is 50/50 steam and windows store, so it can't be that bad.
Of course the difficulty and headaches involved with windows package management are pretty asinine, they at least are an accessible and non-gated platform for both the developer and user, which can't be said for Android and iOS/MacOS.
Enterprises? Forget it.
It's probably still too early to tell, but App Management for Microsoft Teams, updates to MSIX, and better Windows 7 compatibility for companies over-paying EOL extended security support agreements, at least for Microsoft/Office 365 companies, has opened the door to enterprises re-evaluating the Microsoft Store for Business. It might actually replace System Center like it was intended to, just years late.
The .NET bit is an irrelevant strawman. We aren't talking about that, and it has zero relevance.
The Windows App Store is a sad disaster.