My DD is ten too. She's bright but not a high achiever. I am convinced however, that she is a special person who is capable of living a happy and fulfilling life.
I've had lots of chats with DD about the fact there are, what, nearly 8 billion people on the planet. None of the kids in her school are the brightest on the planet or the stupidest. But right now, there's a handful of ten year olds out there who, one day, will do something incredible and, just looking at their English or maths work today will NOT tell you which ones they are.
Each of us is unique. Which, really, is incredible when you stop and think about it.
I've spent time looking with DD at lots of true stories of people who have succeeded. Through luck. Nearly always there is luck involved. And Effort and perseverance.
Stories of people who didn't "find their thing" til late in life are fun. Stories of amazing accomplishment that doesn't rely on academic prowess. Sporting heroes. Explorers and artists and Inventors and activists and leaders and entrepreneurs. Kids who've made a fortune on YouTube or gaming.
Stories of really quite minor accomplishment that have made a difference or done something new. Stories of people who care. Or just happy people who live life in an unusual but interesting way.
Your DS needs a big shot of perspective to lift him up and away. The "now" feels quite horrid, but if he can get through this then better times will come.
And all the high achievers at the village school, they all have to realise they are clever, but smarts won't necessarily get them where they want to be. It's attitude, grit, personality, luck, a nose for an opportunity, a willingness to have a go and take a risk.
So tell DS to dry those tears of frustration and stop comparing yourself to other people. Find some nice friends first off, that is important. The school work, it really isn't the be all and end all.