I've managed it a few times, but not often. Usually I just get a message that "this villager is dead" or similar.

I wonder if it only works if a villager died of disease? That would be logical; doctors can't cure old age.