Is it horrible that as the maid of honor I’m unable to go to a bridal shower out of state?

Long story short, I am the maid of honor in my best friend’s wedding. We both live in the same state but she is wanting her bridal shower to be in her family’s hometown which is totally understandable. The issue for me is that the shower is on a holiday weekend (4th of July) and the flights alone are almost $500. The month of June is crazy with 4 other weddings, one of which I’m apart of, plus other travels and needing time off work. Other financial responsibilities popped up as well so spending $600+ for the shower on top of the bachelorette trip feels a bit strained. I sent her a text expressing how sorry I am and how I would be happy to buy decorations and have them delivered to the shower, send/venmo money for food, drinks, etc and that I would throw her a shower in the state we live in later this year for some of the other friends in this region.

She has yet to respond so my brain is spiraling thinking it’s a horrible maid of honor decision to not make it to the shower?