I think the obvious anwser is because story reasons. Also we are thinking as gamers and not as people. Even if we we had an option to bring recently dead people back to life, I sincerely doubt that many people would be all that willing to take it. Oh hey you got a tumor in your head. Take this shotgun and blow your own brains out. We will revive you soon after and you will be FIINNNNEEEEEEE.
Also, 200gp for a resurrection spell is VERY cheap compared to how expensive it is in-universe. So I guess the anwser why they dident think of it is a combination of game mechanics amd story reasons.
