Hotels Last Minute Deals

My husband & I have been happily married for 9 years and enjoy spending time with each other. But he’s not much of a social person. He doesn’t like to do any activity involving other people. He’s been that way ever since I’ve known him so I’m okay with that except when it comes to family. It bothers me that he never spends time with family- his or mine. I live close to my family but he’ll never go visit and they’re not welcome in our home. If I want to invite them he always complains and threatens to leave the house. This always causes an argument so I end up never inviting family or friends over. I invited 2 cousins over to watch the Superbowl this year. When I got home from church he hid the projector so we couldn’t watch TV. My cousins already had plans & couldn’t come. I told him but he still wouldn’t speak to me all day.
We’ve been in our home almost 4 years and I can think of maybe 2 occasions where I’ve had family/friends over. He goes in the bedroom and will not come out until they’re gone. He calls or texts me constantly asking when they’re leaving. For holidays, I always go visit them alone and have to hear the endless “Where’s DH?” “What is DH doing? Why didn’t he come?” It’s very upsetting and stressful for me so I don’t visit them as I often as I should. Maybe just a 2-3 times a year and they live 15 minutes away.
Last weekend my great aunt died, the last of 13 siblings. A lot of family from other states will be coming to the funeral. My husband & I have the largest home of my local relatives and I want to open our home up for whoever needs a place to stay. I told him this and was met with the usual resistance. He asked why they can’t stay in a hotel! This is Very upsetting for me. I already have to deal with my aunt’s death (she was like my 3rd grandmother). I don’t want to deal with his insensitivity or harassment about having people over. But I don’t want family stay in hotel unless they just want to. I don’t know how many are coming but we have enough relatives to fill up everyone’s home, not just mine. Is there anything I can do to get him to be okay with this? Or at least not cause any extra stress?
What kills me is the 1 or 2 times we’ve ever had overnight guests were from his friends and I never gave him any lip about it.