It's definitely something that deaths and similar events make you think about, but ultimately, I also find myself asking if it would be used at all. And if it was, would it be beneficial?
I have thousands of family slide photos from my grandparents. This is unusual, but they were big photography fans. Nobody looked at them for at least a decade. But about 10 years ago I had access to a nice scanner, so I digitized a few hundred of them, so that we could look at them more easily. Now I have thousands of slide photos nobody has looked at in two decades, hundreds of digitized versions nobody has looked at in one decade, and a handful of ones we printed or such that get looked at more regularly. I think quantity is overrated, and it just becomes write-only-memory. I still take hundreds of photos for myself every year, but I doubt my kids will ever look at them for more than a few hours, max.
And I think there's something to be said for the impermanence of memory for helping people move on with their lives. I thought I was going to die a few years ago - I didn't, which is great, obviously, but if I had, I wouldn't have wanted those who loved me to still be dwelling on me today.
Snapchat is basically the app recognition of this idea that not everything is worth saving, that for 99.99% of stuff the value today far, far outweighs any value in the future. Shame it's such a hard concept to monetize, I guess.
(I say this, but I'm not immune to the temptation, either. If you ask the people in my life, they'd definitely tell you they wish I'd follow my own advice around "remember, you're taking pictures for yourself, not for other people, and don't prioritize your pictures of others over other people themselves." :| )