Fiancé is terrified to go to social events with me

My fiancé and I went to our first wedding together over the weekend and he absolutely hated it due to social anxiety. He told me he wouldn’t go to anyone else’s wedding with me besides my brother’s wedding whenever that happens. I know I’ll be invited to at least a dozen or so weddings in my life and imagining going alone makes me really sad. I’m not a big drinker or partier but I like to support my friends and family at these events. He also won’t go on the family vacation that my sister & brother in laws family are planning for next year, and he said he won’t go to my friends wedding a few states away which is a combined trip w Disney world. He goes to family dinners and smaller more frequent events with me and is very sociable and nice, my family likes him a lot.

Is this normal for some people to be so terrified of social events that they just can’t go, or would this be a deal breaker for you? I’m offended that he won’t try to get over his fear in order to support me at these events, and he’s offended that I’m pushing him to even try.

Update- he agreed to go to premarital counseling with me so we can figure out how 1) he can manage his anxiety and 2) I can support him and figure out when to push him to overcome his fear and when I should just let him be