There is a substantial amount of spam and NSFW posts on the All page coming through already. Most NSFW posts aren’t being tagged as such and are coming right through. I am not sure how this can be weathered but we need something in place fairly soon, I feel like we are days away from rivers of bad stuff, especially via some of the federated instances.
EDIT: I personally don’t care much about the NSFW aspect, more in the lines of what a newcomer will be seeing when they get to the main page. 99% of the newcomers don’t know / care about federation and have no idea how to turn that off. Liability for the server owner is also an element of consideration.
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.