Typically, but it's also watered down to the point of being synonymous with "icky" in some contexts.

E.g. you'll see posts of the inside of wasp nests and the like being marked NSFL on Reddit.

NSFW has also evolved to mean "disable preview", among other things. E.g. it's used to hide the punchline of visual jokes on Reddit.