You can't please everyone. At the end of the day it's important to get along, but changing in order to fit in or fit a mold within a particular group is simply counterproductive. The more you try to be something you're not in order to satisfy someone's expectations of you, the more you come off as being fake or disingenuine.
If it's a real issue, there are always positive, productive ways of getting it out in the open so that at least the opposition can be understood, and if the "sour" feeling is based on reality or simply conjecture or inuendo.
At the end of the day the most important person is your spouse. Nothing should come between the love of two people—even family.