Does "sunny" mean something else than actual sun? Like figuratively?

Native speaker’s answer
Rebecca
Yes, that's correct. It's being used figuratively here, likely to mean "happiness," "energy," or "life." "Rain" here probably stands for sadness, depression, or bad things. It's possible that "Sunny" here is a name that stands in for the person who has brought "sunshine" into the singer's life.