You can do it. I remember when my dad failed a professional test when I was a kid, and the excitement, joy, and pride I felt when he passed it the second time.
Failure sucks! But you'll pass it in October, and I'll pass it in October. And your kids are going to be so proud of you no matter what.