In my opinion, no, it's not an insult. It's a term used when you're referring to someone who has the odds stacked against them, but there is an underlying amount of support that is there because there are hopes that they will win. In the end, even if they don't win, they were regarded as being someone (or if it's a team, "something") that won the people over.