Feeling like a failure

So I just took my second diving test today and I failed. I am so devastated as I tried so hard to do better but I still failed. Not to mention how expensive it is to book a test, and to use my instructor’s car also comes at a fee. I prayed so hard about it last night, and I really felt like I was sure to pass this time. I don’t perform the best academically, I’ve always struggled in school and have never really gotten amazing grades. So it was so important to me that I passed this test to give myself that sense of achievement (and in some ways a sense self worth). I’m feeling so low at the moment, like I can’t achieve anything. I honestly feel like such a massive failure. Like I can never do anything right. I am very insecure when it comes to my intelligence. I don’t think I’m very smart at all so this just makes me feel so useless😢 If anyone has any words of encouragement or a bible verses/passages for me I’d really appreciate it. God bless x