You should read the book 'Rich Dad and Poor Dad'. It really helps you understand, that yes education is important but is that the only way?
You dont have friends, you dont NEED them. Making friends is a 'want' which you can fulfil if you WANT to, but its not a need. You can survive without people, its actually better and helpful.
Instead of friends, make connections. That is a long term goal which has helped many individuals acheive. By connnection I mean academic connections, people who work in certain places who can take you where you WANT to be.
As far as I can read, you study 7-8 hours a day yet you fail. Now, how do you study? read the textbooks? watch videos? practice the course work?
Reading from the text book and course work, is NEVER enough. You're hearing this from an individual who failed their A levels, but is doing finance and is in a stable position with a GPA of 3.5.
"Look outside the box" its a common saying right? but have you implemented it? If you cant find the answer in the book, check other sources. Book a tutor, ask someone to help you. I do recommend finding a solution on your own as its more reliant, cheap and a great learning method to really understand how to study and when to study.
Being bad at something isnt a thing, its the way you percieve it. If you think youre bad at it, I gurantee you, you will be bad at it. If you convince yourself, youre good at it, there is a high chance of you attaining your goals without the idea of failure. Dont be scared of fear or failure, learn and accept it.
your mind right now says, you suck at exams and youre dumb. thats where you're wrong. No one is dumb, its the excessive knowledge you contain. You study long hours and see no difference. try studying short hours with complete focus and utter attention. make short atainable goals.
You never know, your 'dumb' self may end up on the top 30 in forbes.