Lack of sex is causing me to be unsupportive

When my husband told me about this event the other day I flat out refused to go & said there’s too many people, I will get overwhelmed. The truth is, I realized afterwards that I don’t believe my excuse, I faked insecurity to disguise the fact that I resent we don’t have sex anymore (months go by) & I don’t feel like being supportive because if we aren’t intimate I don’t feel supported, loved or honored in our relationship. When we are intimate I feel like we are a team, in-sync & things are harmonious but that seems to be rare these days. I have told him this before. It seems like a reoccurring pattern for me to withdraw support when it gets to this stage, I don’t mean to, like I said, I only realized it after I said that last night. I feel bad, I know I should go and support him as his wife.