It is an unusual name (which is why it sounds awkward), but I would not say it is universally seen as an "awful" name. It's a matter of opinion. The author is probably giving you the perspective of that particular character's thoughts or opinions. What the author is not doing is telling you the perspective of the English-speaking world. It is just the opinion of one fictitious person, intended to make the story more complete. Source: American English (self)

Lindy is a very outdated name and for me as an English speaker, it's just not a very attractive name either. It's also pretty awkward. It's just unattractive as an English name.