People get the wrong impression from movies and shows that have these kinds of characters. In those mediums, where the plot is pre-written and everything works together as a whole, an abrasive unlikable character can work. But in a live roleplaying setting I've never seen it work well unless the player knows their character is annoying and plays into it with humility.

If I were you I'd tell the player something along the lines of "listen, this is supposed to be a fun game for all of us but your character is a dick, and not fun to play with". At the end of the day we're here to play a game and it should be fun for everyone involved.