Yeah, it’s a mess. It seems like eventually they figured out that UWP’s sandbox+packaging requirements were a huge mistake (see Project Reunion/Windows App SDK), but that realization came much too late.
Unfortunately, the execution was a mess. Not having any way to opt out of the sandbox was an insane decision and it led to crazy workarounds; even first-party Windows software has to do things like ship a sidecar exe to bypass the sandbox (the Store does). And troubleshooting issues with the sandbox was a pain, configuring capabilities was a pain, and there was very little in the way of iOS-style user-facing permission controls.
And don't get me started on the marketing; MS flacks kept telling devs how sandboxing benefits users while doing virtually nothing to convey those benefits to users.