I wouldn't call it a fail per se considering how there's NSFW literally in the URL. If your whole instance is about NSFW content, then marking individual content NSFW becomes moot.
That said there should definitely be instance level NSFW flags for federation purposes.