It's a mild insult that we use mostly when we are joking. When you call someone a shrimp, you are saying they are small and cannot defend themselves basically. If someone in the US (my home) called me a shrimp and was completely serious I would begin laughing.