Whirly, very few people would have been ballsy enough to do this course with 330 hours and even less would have got as far as you did. There is no shame in not passing, at least you know what is expected of you next time.
Get drunk, sober up then just go and fly by yourself on a nice day to remind you that you don't actually hate flying and that is why you took the course in the first place - to be able to pass on your love of flying.
Chin up girl.