If the person you are apologizing to is an outsider who is visiting your city or a traveler, then by apologizing for the rain, you show sympathy towards the outsider and you look like a caring native, in this scenario it would have good positive impact though the apology might seem random. I wonder how many people in the sample set were outsiders.