I think a lot of children of the rich and famous do ordinary jobs. It's just you don't hear about them. I mean in reality there's a lot of rich and famous people with children yet the number of those children attempting celebrity careers isn't that big (relatively).
On the subject are there many "nepo babies" that achive success in their chosen non-ordinary career? Whilst no doubt all nepo babies are advantaged by their parents by the fact they get their foot in the door to get roles or gigs. But if they are mediocre or talentless they surely don't become independently successful unless they have actual talent. They just end up being famous doing nothing other than being the celebrity's child and embarrassingly failing at things (mostly thinking of the two Beckham boys here) and get called influencers.
Other ones i can think of are Will Smith and Jada Pinkett Smith's children all got breaks (because of who their parents are in acting or music and modelling) but I don't think any have achived success, Jaden tried acting and absolutely got the roles because of Will Smith - he wasn't great and his acting career went nowhere. Think Willow is a DJ - she's possibly successful but don't know enough to comment only read an article where she was trying to justify her career and saying it wasn't down to who her parents are. (There's a third but I know nothing of him.)
I reckon Sofia Coppola got awards because deserved them. Whether she'd have ever manged to gain recognition or funding at the very start without Francis Ford Copplola I can't say. Bet there massive amounts of incredibly talent filmmakers out there who don't get the break they deserve.
I'm rambling,.sorry!! Will stop now before I head down a rabbit hole.