For example, Radarr is an extremely popular tool for managing movies. It connects to usenet and torrent clients, as well as indexers and movie databases. It makes maintaining a home movie collection seamless. Radarr is not in major package managers, and requires the CLI for install (https://wiki.servarr.com/radarr/installation#linux). In Windows, I double click an .exe. In Linux I have to follow a reasonably complicated and time consuming installation process, full of opportunities to misconfigure the install. Radarr isn't a super hardcore 1337 program. It's a very common application aimed at everyone who runs Plex. Until a distro has a .exe equivalent for all applications like this, it's just not going to be a competitor to Windows, for users who need more than just a web browser, and those who are not IT administrators.
Bottom line: make it so users never ever, for any reason ever, need to use the CLI. Until then, most of us will be sticking with Windows.