Let's not get into diagnosing a person if you don't have the professional ability to do so.

Also, all I saw from you were requests of him and his behavior. Did you talk about getting a hotel so you wouldn't have to worry about sex/noise/privacy? Did you talk to your family about the rift in political beliefs and his passion for them?

You may be hurt but this, but I'm not sure you went into the situation intelligently. Like all of life, this is a learning experience. If your husband didn't do this maliciously (which you said he hasn't) and he has apologized (which you said he has), it sounds like you both need to let go of there being someone that was right or wrong, and work on having a better experience next time.

Also, have the hubby write a short, polite thank you card for the visit and have him tag on a brief but thoughtful apology if he'd be willing to - not for how he feels, not for bring right or wrong, but for possibly contributing to a little discomfort, and to make it clear that he's happy to be part of the family.