I have been concerned about this problem as I have aged, too. I'm 61 now and in decent health, but I have no kids to leave my work to. I doubt that my wife's nieces and nephews would be interested in them. So I have no idea what will happen to my "artistic" photos.
However, I have been shooting photographs of ballet companies and dancers here in PR since 1984, and I have a huge collection of negatives... but not too many contact sheets. I have spoken to the director of Ballets de San Juan, my major client, about my archives. They are interested in them, but have no archival storage space in which to keep them... or other archival photos that they have kept for over 40 years. Still, I would probably donate my negatives of their performances to them before I die.