But Valve I'm dead? Why can't my family play the Steam games I have bought?

I don't see the big problem here. You don't need in the will to give somebody access after you pass. Just make a note in case of emergency with your credentials if your steam games are that important. Or just add them to Steam Family share list.