I think you have to be very careful how you push your children.
My DF couldn't go to University because his parents couldn't afford it (in the 50s). That was always the thing he went on about. He was clever and very sporty.
My DM missed out on grammar school because she broke her leg and missed the 11+
My brother and I were considered clever and expected to do well. We did extra curricula activities and were taken on educational trips, BUT I absorbed the message very young that anything I could do one of them could do better. That does nothing for your self esteem.
DM baked, did all the DIY and car maintenance, knitted, crocheted, iced cakes, was great with babies, painted and sketched, cooked, sewed all our clothes - anything practical she did it. DF was sporty, played cricket, football, table tennis, and was clever - huge general knowledge, always beat everyone at quizzes and board games. They both sang and danced.
If I was 2nd in class they wanted to know why I wasn't first. Why did I get B+ and not A. We spent a summer visiting castles and it was so boring.... constantly quizzed on who lived here, what battle was here, when was this built. DF went on and on about the war - who cared?
I passed the 11+ but grammars were made comprehensive while I was there and suddenly it was uncool to be clever. I was never popular but I kept my head down so I wasn't noticed by the rough kids. DF chose all my options. I wasn't allowed to take the subjects I wanted because they "wouldn't get me anywhere". I ended up dropping several subjects I really hated just before the exams, and failing the rest. At 11 I was predicted 10x O levels. At 16 I achieved 5, not including maths.
I was the last kid picked for any sport at school and faced the ritual humiliation of failing at every single PE lesson. I couldn't do any of it. Couldn't run, couldn't catch or hit a ball. Had weeks of semi-private tennis lessons and still couldn't do it.
I didn't know what to do after school so DF got me an application form for the civil service. Ended up in a job I absolutely hated and going nowhere. Got married young to the first boyfriend who didn't dump me, because all I wanted was to leave work and have a baby. Had several babies in quick succession and realised that I wasn't cut out to be a SAHM either, so have put more effort into work and finishing my education. Now I'm too old to get on and I see all these bright young things who can't even spell rising higher and higher in the organisation, and I just wonder what the point of it all was.
DB just took the easy road altogether, failed all his exams, dropped out of everything and ran away to live in a squat. Luckily for him he has natural talent where computers are concerned and was able to pick it all up in his 20s and still get on.