Hocusfocus I am sure he will be fine - he will get there in his own time - our primary/secondary education system is not very good at dealing with non-conformists! I hesitate to recommend this as it is the most viewed TED talk ever but if you haven't heard it read/listen to Ken Robinson for some uplifting positive stories!
I have one - bit long sorry - DD3 was very immature academically and not ready for formal schooling until she was about ten. She would only do her schoolwork if a teacher sat with her - she would rather wander around the class telling the other children what to do. If we or they put pressure on her to knuckle down and work she would just cry - she spent whole days in tears - and was known at school as the crybaby - she even got a Christmas card one year addressed to the crybaby 
.
Homework was a nightmare - it would take us 4 or 5 hours to get her to complete a single worksheet and in the end I just told the school we were not doing it anymore because it was so disruptive, negative and upsetting for us all. It got to the stage that I really didn't care if she was bottom of the class if trying to do well academically was going to cause so much distress. She didn't read until she was 8 and they put her in a room on her own with a teacher to do her KS2 SATS (which she actually rather enjoyed - she likes an audience!).
The school tested her for everything going but it just seemed to be a lack of interest and concentration. The thing was she was/is very articulate and opinionated with a huge vocabularly and could talk your ear off - if she could have done her work orally she would have been fine. I took her to join a choir when she was 7 because she loved to sing (we joke that she came out of the womb singing and hasn't stopped since!) and that gave her some reason to learn to read and concentrate.
She is in her first year of GCSEs now and is absolutely flying doing subjects she loves. I do not have to hassle her to do her homework and she got subject prizes the last two years and regular commendations. She really has a lot of creative talent - no idea where from - I have zilch. All the teachers love her because she is so interactive and enthusiastic if still rather opinionated and they are very good at accepting some rather 'imaginative' homework instead of standard written work! She is never going to be academic like me but as far as I am concerned as long as she passes English and Maths with a C that will do. Her love is art, crafts, textiles but particularly drama and music which she is just a natural at and her voice has been described as 'special and magical'. She is getting asked to sing regularly now and she mentors younger children at the local youth theatre. She is just brimming with ideas and joy and fun. I cannot deny it is a relief as 5 years ago we were very worried indeed.
To be honest, I think all the talk about reaching potential in primary is rubbish and puts far too much pressure on parents and children (and teachers TBH). Education is not a race that you loose if you fall behind at some stage because you don't get the grades you want/need the first time you try. I have seen students 'not reach their potential' until they are doing a degree or even a PhD and suddenly blossom as they 'get it'. I have also seen undergraduates fall to pieces because bereft of parental and teacher helicoptering they just cannot cope. IMHE the best thing you can do for him is to help him find his own way by letting him fail, supporting him when he does and giving him opportunities to learn for himself, try new things and become an independent confident learner.