“I am sorry that you have X” is either an expression of sympathy or pity.

For instance, in general, “I am sorry to hear that your father died” means “I am feeling sympathetic to you for your misfortune”.

It does not mean “I apologize for the death of your father” except in the extreme case where I was responsible.