The study of unusual place names is called Toponymy. Have you ever lived in a place with a strange name? What happens is that everyone who lives there becomes oblivious of the name's amusing connotation.

Another common occurrence is that people in the area refer to the place with a strange pronunciation. For example, I stayed for a while in charming village in Cornwall called Mousehole. Did the people who live nearby pronounce it Mouse Hole? No, they refer to it as 'Mousle', the aitch is silent.