My perspective is that my parents - both involved in education - took great pride and plesasure in any academic success I had. This made them happy and they praised me. They also became quite harsh negative when, in my teens, I was unhappy at school. Really all they wanted of me was for me to be clever and succeed academically.
It seemed to me that there was something very conditional in their affection. They weren't interested in my friendships. (Most of my friends who were perfectly pleasant children/young people were banned from the house.) They weren't really interested in me. My only memories of warmth and approval relate to having done well in tests.
So as a parent, I've reflected on this. Yes learning opens doors - not just financial ones, but there are personal rewards too. It can foster an interest in/engagement with the world. On those occasions when my child and my stepchildren were unhappy at school or disengaged my husband and I intervened to try and put things right.
But I suppose the most important thing to me in terms of children's well-being is that children know they are loved. Loved for who they are rather than how well they've performed. (This doesn't mean they're indulged and/or that there are no expectations of them.)
What concerns me when I read about parents who feel very driven to direct their children in particular ways, is that those children may feel they only are given/deserving of their parents love in so far as they conform to these expectations.
It also seems to me that many high-earning professionals are actually very unhappy in their work because of intense, unhealthy competitions - long working hours. It sometimes seems to me that ensuring young people have a skill or a trade - the sorts of things that will always be needed even in a changing economy - may be more in their long-term interests than, say, guiding them towards medicine - in which conditions for young doctors within the UK are extremely poor.