@Floatingfancy
You poor thing!!! As a number of people have said, not passing your driving test has naff-all to do with intelligence my love!
It's soooooooooooo hard. (Well it was for me ha ha
)
I took, wait for it......
SEVEN attempts to pass. Started to learn at 18-19 (in the late 80's,) had about 15 lessons, and took a test: FAILED. Took another 6 lessons, took another test: FAILED. Took another 6 lessons... took another test (you can probably guess what's coming... )
So after the third fail in one year, (and feeling utterly shite,) I got a new job at the age of 20, in the middle of a big city, and moved there. Didn't need to drive for 4 years or so, as I worked 10 minutes walk from my flat, and everything was within 5 to 20 minutes walk.
Moved back to my home town at 24, met my boyfriend (now husband,) and we moved in together after about a year. He had passed at 17, and drove us everywhere. I felt shit about it, even though he didn't complain. It took me 70 minutes to get to my new job at the other end of town, but was a 12 -15 minute drive.
So I took another 10 lessons, and a 4th test - FAILED. 10 more lessons, and a 5th test - FAILED. 10-12 more lessons, and a 6th test.
FAILED!!! For a 6th time!
So at 26 I had failed 6 tests and had also had around SIXTY driving lessons since the age of 18, I gave up.
Got to 30, and had a couple of kids by then, and it was SUCH a fucking pain trying to do anything without a bloody car! (Especially as I worked 3 days a week!) My town was nice, but the public transport was a joke.
Soooooo I took around 9-10 lessons again and booked another test.
At 31 y.o. and with test No. 7............... I PASSED!
Been driving almost 15 years now!
Sorry rambled a bit then. 
I know I could have gone for an auto, but I know a few people who can only drive autos and it does restrict them a bit with jobs...And auto cars are more rare, and a bit harder to come by. I also REALLY wanted to pass in a manual!
But I agree it's probably a good idea to pass in an auto, so at least you can drive. You can always move onto a manual later. To be honest, if I had failed test No 7, I would probably have tried an auto test, as I really needed to be able to drive by then!
Good luck!