These signs (if phrased in this way) are slightly misleading. I doubt anyone is ever prosecuted for just being insulting. What happens is you'll be asked to leave if you're aggressively rude and if you refuse to leave then eventually the police might be called.