SSDs won’t hold data for much longer compared to HDDs
Realistically this is not a good reason to select SSD over HDD. If your data is important it's being backed up (and if it's not backed up it's not important. Yada yada 3.2.1 backups and all. I'll happily give real backup advise if you need it)
In my anecdotal experience across both my family's various computers and computers I've seen bite the dust at work, I've not observed any longevity difference between HDDs and SSDs (in fact I've only seen 2 fail and those were front desk PCs that were effectively always on 24/7 with heavy use during all lobby hours, and that was after multiple years of that usecase) and I've never observed bit rot in the real world on anything other than crappy flashdrives and SD cards (literally the lowest quality flash you can get)
Honestly best way to look at it is to select based on your usecase. Always have your boot device be an SSD, and if you don't need more storage on that computer than you feel like buying an SSD to match, don't even worry about a HDD for that device. HDDs have one usecase only these days: bulk storage for comparatively low cost per GB
And oftentimes some or all of the metadata that helps the filesystem find the files on the drive is stored in memory (zfs is famous for its automatic memory caching) so seek times are further irrelevant in the context of media playback