To be fair Ubuntu is still okay especially starting out, it's one of the more polished distros with a ton of online documentation when you need to search around and figure out how to do things. And no one says you have to stay with a distro, once you're comfortable with Linux it's easy enough to check out other distros.
That aside a lot of people have been recommending Mint for new users so that's definitely one you can check out if you want to try branching out now rather than later.
PS - Nvidia has a less than stellar reputation for their Linux drivers, you may want to consider reading up on that for whichever distro you choose. I have an Nvidia GPU (old non-Quadro class) running on Debian, works fine now but I did have a few false starts getting it going properly at first.
VS HDD seems a bit unlikely. The typical cheap optical media isn't designed or meant for long term archival. There are more expensive types that are meant for long term storage but I'm pretty sure that's not what OP is talking about, especially if it's just random blank discs from thrift stores, etc.
But to your point even cheap optical media might outlast SSDs since those tend to lose their saved data if stored unpowered for x years.