No, "putain" is not a common insult, it's a common vulgar interjection, like "fuck" or "shit" - it's used like that all the time. If you actually call someone a "putain" and not just say it when you stub your toe or something, you are calling them a whore.