breastfeeding a five mont old and pregnant again

Hi y'all, I have a beautiful five month old little girl and recently found out we are welcoming a baby in November. Since I have found this out I dread breastfeeding and honestly it seems my little girl has decided she needs to eat literally ten times a night. I'm pregnant and tired and every once of me want to just put her on formula. My husband is supportive about whatever I choose but he brought up a good point that I don't sleep when she sleeps. I have always had trouble falling asleep and it takes me hours sometimes. I'm not sure if I should give up on breastfeeding all together, just give her formula at night or all the time... I feel stuck cuz I love our bond but I'm pregnant and I need rest .... help!