Of course it's horrible. Life is all there is. When you die, from your perspective, that is the end of all things. That's pretty horrible. Just because it's natural doesn't make it good.
In meta-ethics, the question was "What does it mean for something to be horrible in the first place? How do you decide something is good or bad in the first place? If you fear your own nonexistence, why do you not fear the nonexistence of, say, unicorns?"
I never took an evolutionary psych course, but I read a bunch of their textbooks. I'd imagine the answer they'd give is "Of course you believe death is horrible. If your ancestors didn't, they wouldn't have an aversion to death, and so they would never have been around to reproduce, and so you wouldn't have been born. Therefore, we select for animals that fear death, because all animals that do not fear death never come into existence." There's something comforting about that perspective, knowing that our fears are nothing but evolutionary chance at work, but it's interesting to think that our fear of nonexistence is a consequence of our existence.
1: http://chronicle.com/article/Is-Death-Bad-for-You-/131818/
So? Why does that matter? From my perspective, before I was born and after I die are equivalent on account of me not being able to have a perspective. 13.8 billion years of the universe where I didn't exist wasn't horrible before so I don't see why it will be so horrible in 60 or 80 more years when I don't exist again.