That's my worry, AlwaysOne. I think it will end up being pronounced to rhyme with "Melody", and might be mistaken for it. Also, DS has a very classic British boys name, so I'm not sure how well the would go together, IYSWIM. It is pretty though!
I thought it probably should be said "El-oh-dee". That said, Melody should probably be pronounced the same, but around here (Midlands) it isn't, it's more like "ELL-ur-dee", the the emphasis strongly on the Ell. I'm probably wrong though, I've only seen it written down! How would the French say it?
My baby is Elodie. We have no french heritage, though I do speak French, but I actually prefer the name with the English pronunciation. We call her ELL-uh-dee, but I am ok with it if people call her ell-oh-DEE. We had a couple of elderly people struggling and going with the godawful el-LOAD-ee, but that seems to have stopped, thankfully.
Everyone seems to really like it, and lots and lots of people have really raved about it. We've only had one or two people go 'oh...that's...interesting'. Only one person has confused it with Melody - nobody else has made a link, which surprises me. Also, nobody has tried to shorten it to Ella or Ellie. Nobody has thought it was made up - more educated people know it's a French name, others have assumed it's some sort of foreign name they haven't heard before. I think it's a good one as it's accessible, pronouncable, spellable by English people.
I hadn't met another Elodie, but there are now two more locally whose mums blatantly copied me so it is getting more popular, at least in the sort of area I live in. But I don't really care - I love it, and it suits DD perfectly.
My 2.5 year old is Elodie. Like peppinagiro, we are not French although we do have a family house in France and do speak French and I think that was where I picked it up from. It just sounded so beautiful to me and unusual for the UK - given that we have a VERY common S surname I wanted something no one else was using basically. I think there were 211 registered the year she was born (2011) or the year after, I forget which. Never met another one (we're in Hampshire) and have had nothing but positive, oh isn't that pretty, unusual responses etc.
We pronounce it Eh-low-dee but do get the odd Ella-dee. I don't really mind, she knows her own name and can say it now. Her friends can all say it too.
my DH is French and it is on our list for DC4 if a girl. So much prettier with French pronunciation but the French/English difference is small so she will still recognise her name if said by either national (bilingual family living in UK).
of our other three DC, one has a French name, one a very English name and one a celtic name (to reflect our very mixed heritage, not just for the fun of it!) and they do flow together well. although all 3 names are 3 syllable so they balance well. foreign names don't always sound odd paired with an English one, but I would expect there to be a reason to use the foreign one tbh.