We discussed this subject a while back.
I think art is about revealing the human condition. If you don't have the stomach for it then don't do it.
Some of the best images we have though, are ones that reveal tragedy or despair in peoples lives. Migrant mother, girl running from napalm, civil war stuff, etc.
That being said, I'm sure it can take its toll on the photographer over time.