I've never actually died in my dreams- I've come pretty close to dying but I always seem to wake or go to another dream before it actually happens so I coudn't really tell you. I bet, though, that dying in one's dream might be pretty traumatic at the very least.