A name can be beautiful to say and historically heavy to translate. This happens more often than people realise, because names carry their origins from cultures that valued different things. A meaning that sounds sorrowful now may have carried different weight in its original context.
Names worth knowing about
Mallory comes from Old French for 'unlucky' or 'ill-omened'. Cecilia, from the Latin root, traditionally meant 'blind'. Deirdre, from Irish legend, carries the sense of 'sorrow' or 'broken-hearted'. Claudia traces back to a Roman root meaning 'lame'. Each name is still beautiful and still widely used.
Does the meaning matter
For some parents, yes. For others, the sound and the centuries of use far outweigh the etymology. Cecilia is a deeply loved name with a rich musical heritage, and the literal Latin root rarely registers. It is a personal call, but worth making consciously.
A name is the sum of everyone who has ever carried it. The original meaning is only the first word in a much longer story.