Ah I know the feeling far too well. If it's any consolation, I failed my CBAT twice - a kick in the gentleman's area for sure.
I did what someone else recommended a few posts up and went to my AFCO and knocked on the door of the Royal Navy and enquired into the Aircrewman role and FATS (Naval aptitude version of CBAT) thinking maybe I could retake the tests sooner than having to wait the 12 months and as the tests are identical - you still have to wait for your year to elapse before re-attempting the Aptitude tests.
I concur with what others say, perservere and wait for the year to elapse.
Best of luck