It won't send to all moderators, only to the moderators that are specifically assigned to the forum that the post is in.

There is also an option under My Stuff -> My Preferences, to specify if you, as an admin, want to receive notification emails.