Sorry to hear that, Jay.
That's actually one of the things that scared me sober--not so much dying (and I was never seriously suicidal) but the thought that nobody would bother to come to my funeral. Oh, my kids would, my immediate family, even my first husband, but I had no friends and no life outside of work, and I wasn't close to anyone there. Basically, I don't think anyone would have cared that much. And I was doing it to myself.
As for your wife's reaction, it may have hit a little too close to home (in more ways than one).