I'm in 2 minds about this - if we're talking about anyone worth their salt, who goes out into the world and makes a go of it, well, they pretty much always become 'greater' than their name, IYKWIM. I mean, there are some pretty ludicrous names out there which haven't held people back - Condeleeza springs to my immediate mind, but there are loads of others.
Having said that, there are plenty of names I just would never choose for my own child, because I think they're twee or silly not to my taste, or will date very quickly and, basically, because I'm naming a human being, not a doll. Lola is the first name that sprang to mind and I see someone else already mentioned it upthread.
Tallulah, FFS. Molly is nowhere near in the league of these names.
Of course, Tallulah is as likely to be Prime Minister as Catherine is - I just imagine that Tallulah's parents would probably be a bit disappointed in that (hoping, rather, to see her open her own nail technician business and marry a footballer), whereas Catherine's parents would be delighted and proud.

I won't deny - I judge freely - but the parents, not the person.