Is this phrase an insult and a rose by anyother namewould smell as sweet?

No, it is not an insult. It is from a line of a play called Romeo and Juliet. The line is "What's in a name? That which we call a rose by any other name would smell as sweet". It means that the name of something does not change its essential qualities.