I’d suggest it can be used even more lightly than that, to express that someone is pitiable in some way. My boss, who is from the Carolinas, was talking about her mother who had just had a stroke, and said “my momma, bless her heart”.
As you say, there are shades of meaning, and context is sorry important.