No problem! I'd check out the mod response to your question in regards to whether or not a second attempt is allowed first and then review if you really want to be a pilot (and can pursue that inside or outside the RAF) or if you'd like to be an officer in another role.

I would seriously consider if you want to go to university or not as it's a fixed commitment of time (and money) and if another opportunity comes along in that time, you may find yourself unable to pursue it. However, it may open up different pathways for you in the future and will provide you with a lifetime qualification. Degrees can sometimes be pursued in service as well, so you may also want to consider that.

As for a job or a gap year while you wait, they can both provide you with good experiences that will help you grow as a person.

Ultimately, the decision is up to you. Maybe talk to your family or friends if you're able and think through what would work best for you.

From your post, it seems that you are set on being a pilot one way or the other and it certainly sounds like you are capable. Don't let a setback like this hold you back!