Do I back down as a bridesmaid?

My friend has 3 bridesmaids which includes me.!

Yesterday I found out I'm pregnant! I'm so happy! My friends know I've been trying for a long time. However, my due date is her wedding day and it's a long drive to the venue...while im thrilled I'm finally expecting, I dont think I'm going to be able to attend the wedding.

Ill be 5 months for her bachelorette party but were flying and obviously I wont be drinking and I won't want to go to a club where people are packed like sardines with loud music....

What should I do? I dont want to upset her but what choice do I have!?