I’m a fan of the “just dive in” approach. You may encounter issues, but researching the solutions is where you really begin to learn. I personally like Fedora, but any of the other distros mentioned are also great choices. The great thing, if you don’t like it there’s tons off other options to try.
Bit of a side note; when I’ve had users with low storage and too many apps, I’ve had some success moving them to PWA’s. Social media apps in particular seem to be storage hogs.
It can definitely feel overwhelming, so start simple. Install a basic well known distro; I’m partial to Fedora, but Ubuntu is also a great choice. You’ll learn a ton just by using it day in and out for typical tasks. If you need help reach out to the community. If anyone comes off as rude I recommend just ignoring and blocking them. Using it will eventually come to feel second nature like MacOS or Windows. Enjoy!
For comparison purposes nextcloud.com offers a solution as well.
It depends on what you are trying to learn. If it’s just using it as a desktop then it’s more a matter of just using it for a while to change your muscle memory from Win or Mac.
If you’re looking for more of a command line/server experience, most distros have excellent documentation. This may be a minority opinion, but I personally like Oracle Linux (a Red Hat clone) and their documentation; https://docs.oracle.com/en/operating-systems/oracle-linux/index.html
I also like FreeBSD which isn’t technically Linux but very similar in a lot of regards. They also have excellent documentation; https://docs.freebsd.org/en/
Ultimately, which distro you wind up liking is entirely subjective and one of the great aspects of the open source world. Oracle in particular you may see a lot of hate towards, but I’ve always had good success with their products and support. Best of luck!
I’d say if you plan on using it any public places, or if you don’t have full control over all the computers/technology in your home network, it’s a good idea to run one. It’s a nice last resort should someone on the same lan have a piece of malicious software.