Just wanted to share my experience… I went for a sweep at 40+6 weeks, which was unsuccessful, the midwife said she “failed” to be able to perform it as my cervix was too high and was tightly shut (0cm). She booked my induction (midwife recommended that this was 4 days later, but I pushed for this to be 6 days later, on the agreement that I would not be allowed the out-patient induction and would have to remain in hospital for the entire induction period - this might differ depending on your hospital).
But I remember feeling the exact same as you - so deflated and I burst into tears when I got into my car to drive home and resigned myself to an induction. I read up as much positive induction experiences as I could to prepare myself, which really helped to relax me about the whole experience. I also tried to increase my oxytocin as much as I could by watching mushy feel good romance films, in a dimly lit room with candles and fairy lights etc - anything to make me feel warm and fuzzy, while doing a figure of 8 with my hips on my birthing ball.
2 days after my failed induction I started to feel mild cramping, lost my mucus plug that night before bed and baby made a very swift entry to the world the following morning (3 days after the failed sweep and 10 days past my due date). It is very possibly for things to change very quickly. Have you asked your midwife for a second sweep? I had a second one booked for 3 days after the first one, it might be worth asking your options.
This last stretch of pregnancy is the hardest!! Especially when you are in pain and uncomfortable, every day overdue feels like a lifetime. You will have your baby in your arms in a matter of days, so try and keep thinking of that.
Good luck for when baby arrives, it’s the most magical moment when you meet your little one for the first time 🥰