Although the biblical Naomi asks the people to call her Mara there is no evidence that they do so. In fact the evidence suggests the contrary as even after that verse the narrative continues to call her by the name Naomi.
I was once told that the Hebrew roots of Naomi meant "Joy of Jehovah" rather than simply "pleastantness" but I don't know where that person got their information from.