How do you balance other peoples upset with your endometriosis?

I was meant to attend a concert on yesterday, but I woke up on my period and obviously I couldn’t go. My best friend made me pay for the hotel cancellation fee which I guess is understandable since I am the reason we had to cancel. But she was really off with me, like she went home a couple hours later and said she felt really disappointed. I understand her feelings are valid but it made me feel so guilty, it was the first time in years I’ve had to cancel a show.

I feel I get this a lot, my husband said “he hopes this doesn’t happen again in Easter” because he’s throwing a party for his friends at our house, that made me feel even worse especially because he was more concerned our friends would judge me and the endometriosis more than feel sympathy. I get people are upset but this really really made me feel so invalidated and awful, but I need to understand peoples feelings are valid. On top of this I tell people there’s always a chance because I have endometriosis, that we will have to cancel. But this whole weekend I’ve felt really like a burden on my family and my best friend.

Edit: Sorry my husband is literally a golden retriever and very lovely he just is autistic and doesn’t understand his wording, it just really added to my already shitty day. Plz he’s so lovely and I’m terrible with wording, but it’s more friend and when I say “I get this a lot” I mean from friends or his family. BUT he himself is lovely he just accidentally made me feel bad he’d be very upset if he knew but you know, just an all round bad weekend methinks :(