I did previously make the effort to have a look through my photos each year and print a selection out to make an annual album but I stopped when I lost motivation as I never looked at them nor did anyone else. It has been something I've been thinking about though when looking through photos of my grandparents which must be around 80 years old, they've faded and the quality isn't great but you can still make them out. Even putting aside technology not failing who knows will there be anything compatible with it, watching retro channels working with storage and similar from the 80s it can be quite a challenge at times reading the data.
(Wading in late, sorry)
My dad has an iPad and my sibling has a habit of loading it up with photographs of the grandchildren, days out etc. I take the pictures and print them out for my dad, who much prefers sliding them into a polypocket ringbinder which he can just lift off the table and leaf through whenever he feels like, showing it off to visitors without having to dig up the iPad and remember how to turn it on.
The thing with digital data though (as opposed to digitised data - something that was originally in an analogue format) is that if you are reasonably careful, it's incorruptible. You can only make so many prints from a negative before you end up bleaching the negative but you can churn out copy after copy after copy of a digital "original" and all the copies (can be) identical to the original down to the last binary digit - and might as well be originals themselves.
So the "medium" in which a digital image is stored becomes less and less important. Got some old photos on a Smart Media card?
Quick, while your camera or card reader still works, copy it on to whatever you now use for storage, and you don't need to worry about the "original" being lost.
Does it matter if the storage unit I use for photos runs on SATA spinning-rust hard drives? No, of course not. In the medium term, as the drives die I will replace them with more SATA spinning discs, maybe even SATA SSDs (solid state discs). The data stays the same.
At some point, the unit itself might die, but that's ok because I have backups and the backups are identical in every respect to the originals.
At some later point, it might not be possible to get SATA discs, but when that day approaches I will obtain a new unit which might run on (say) NVMe storage and after a little bit of copying, the data is safe and accessible. In the distant future, a grandchild might have a couple of petabytes of storage surgically implanted in a thumb. If they choose to copy my digital archive, it will be identical to the original - and they can "touch thumbs" with their siblings and cousins and each one of them can have a complete set of "originals".
As for the original thread title though; I have a low-end DSLR which is now nearly 14 years old and 10 megapixels. I have a new-to-me phone which is two years old, and is supposed to have some of the better cameras available, including a "main" camera which produces 12 megapixel images downsampled from a 108 megapixel sensor (9 sensor pixels are combined into one image pixel). At a guess, and adjusting slightly for inflation, the MSRP of the phone was about the same as the MSRP for the DSLR. There is absolutely no comparison. Even with the "kit" lens and JPEG rather than RAW, and even just when viewing on the living room telly, the DSLR produces images which easily beat the phone camera in just about every respect... but as I'm sure someone has already pointed out, the best camera for the job is the one you have with you, and I'm not in the habit of carrying my DSLR everywhere I go.