Xbox 360 Red Ring of Death questions?

I have heard of the Red Ring of Death, and I have not recieved it yet. But, why is it called the Red Ring of Death? :/
Is it because it overheats? If so, what's the point of the "of Death" part. I mean, if I saw it, I'd scream.