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.
Adult content IS invisible by default, assuming it is properly tagged as such. In the meantime you can block certain magazines / communities that don’t adhere to that individually as well.