That's not practical. It is unlikely that a moderator would always be available to "approve" a site at all times. In addition, it could become quite a burden during hours of peak usage to go through so many sites.
If your concern is great enough, try sending a private message to a moderator or two. Should the user whom you're reporting be abusive enough, their sites can be NSFW'd (if necessary) and reported to Max for review/deletion.
This is only for abuse (large quantities of spam, molesting a user, etc...) Mere disapproval of content is unlikely to get anything done, since it is a not a moderator's duty to judge sites solely by their content preferences.
Thus, I would propose allowing NSFW sites that receive a pre-designated level of popularity (a number of views, a certain rating, etc…) to have a “review” option, where they may be forwarded to a moderator. Should they be deemed SFW after the creator makes his /her changes (yet still be NSFW from a previous flag), they could be changed by the moderator. Why do I propose this? Because there are a lot of good sites out there that are currently NSFW; this would give those sites a chance to fairly become SFW.
There is currently a glitch where a site flagged as NSFW by anyone will automatically become SFW if edited by the site creator in any way. This has been exploited numerous times to undo moderation decisions, although it should be easy to fix (all moderation is logged.) A question raised from this is how one can change a site from NSFW to SFW with the appropriate permissions, should they wish to repent (perhaps just telling them to recreate the site will suffice, but popular sites may be a different story.)
Zalli's recent comments: