D&D is a supposed to be a fun cooperative game. If a player wants to "role-play" a character that won't play well with other, then that player should re-roll a character that will or simply don't play.

Some party tension and disagreements are okay as long as those feelings don't undermine the main premise of why everyone is sitting at the same table in the first place.