You really have to lean into the concept of multiple intelligences. And the fact that high school favors a particular kind of brain. Social IQ, street smarts, executive function, hands on skills, athletic skills, even just being a good person- these are all intelligences your child may have and you should find a way to grow and celebrate them.
I concentrate a ton on self esteem for my dyslexic.
He’s aware that high school is great for fast readers, good memorizers, and/or kids who sit still for a long time. He knows plenty of “smart” kids have no street smarts or interpersonal skills. He has things he’s good at that make him feel smart, albeit in a different way.
It’s a long hard road!