I think it's just because that's what people say to others when something goes wrong. You have cancer? I'm sorry about that. Your dog died? Oh, I'm sorry. It gives them something to say that isn't too awkward, is socially acceptable, and conveys their sorrow for you.