This is a set phrase that people say when someone tells them something bad. You say this to show that, although you don't like to hear that, you are glad that the person was honest.