I have an Edward and considering Sophie if dc2 is a girl. Does this automatically make you think of prince Edward and his wife? Dh doesn't think so but he doesn't know any of the royals names really beyond Will & Harry etc let alone thier partners!
We're all set for a boy but other suggestions for a girl welcome.
It's funny because when you said it in a Baby Names forum, I thought, Oh that's Prince Edward and his wife, but then I thought about it and realised that I actually know two siblings who are Edward and Sophie and it has never occurred to me before, so in 'real life' I didn't ever notice. Sophie is a lovely name, by the way.
I don't think many people would make the connection, definitely not their peers/younger relatives etc. Works fine. Like pilates I prefer Sophia to Sophie- feels more elegant and is nicer for when she's an adult.