"You're such a pussy" or "Don't be a pussy" can definitely be used in a derogatory fashion, especially in groups in which social status is dominated by masculinity.
It can mean, for example, variations on "Don't be so timid", "Stop expressing your fears", and "Take more risks".
Indeed, I have heard "Don't be a bitch" be used in almost the exact same way.