My impression was that Notch is fine with mods, but he just doesn't think there's a way to make Minecraft very moddable without effectively open-sourcing it, which he doesn't want to do.