As a whole, has our community missed the point of labeling a question NSFW?

I thought the point of putting “NSFW” in the title of a question was to enable people to have only work-friendly content on their screen and to “hide” age-sensitive discussions from the kids that hang out here. However, I rarely see an NSFW question title that appreciates this reasoning. Rather than providing a discrete title that hints at the question, people nearly always use a blatantly NSFW title that completely spells out the question. Doesn’t that defeat the purpose of labeling it NSFW in the first place?

In case someone doesn’t know, “NSFW” stands for “not safe for work” and is used to distinguish adult content.