AITAH for refusing to visit in laws bc of house temp

My (36F) husband’s (37M) family lives out of state. We are in the DC area and they live in southern Mississippi. Every summer, we spend two weeks visiting. My in laws are great, except for one thing. They keep their house (in the summer) at 80 degrees. It’s unbearable. I do not sleep. It makes me nauseous. If I try to ask for more AC, they oblige for 10 minutes then complain about being too cold. My husband is also miserable, but he deals with it. Tonight, I told him he’s more than welcome to visit this summer, but I will not be joining him. It’s not relaxing for me. I do not want to use my vacation time to be miserable for two weeks. He got upset and said spending time with his family and his wife together is important to him. He said I was being selfish (I am being selfish, but I don’t think it’s a bad thing here). I explained I understand that, but unless we can stay in other accommodations (like a hotel) or if his parents agree to make the interior cooler for the visit, I will stay behind. Of course, he wants to stay with his family. But he won’t say anything to them about the temperature. This upset me. I told him part of being married is watching out for the wellbeing of your partner and of course it escalated. So have at it. AITAH for not visiting my in-laws until something changes? It seems like such a trivial issue, but it can be unbearable getting minimal sleep, sweating all the time, with no relief for 14 days straight. Editing to add: it would be difficult for them to travel to visit us, especially for two weeks. They do visit us, and we see them multiple times a year. Husband’s relationship with my family is great. My family lives closer, so it’s easy to spend a weekend with them here and there.