Could I name sisters this or is it too weird?

I wouldn't have noticed before you pointed it out. I think most people don't know that Ariel had a daughter named Melody, and I'm sure they wouldn't mind even if they did remember. They're both pretty names and go well together! :)