Good. It's supposed to be Doom, not Resident Evil.
The heavy metal Doom games makes the player (at least me) feel as if they're a real badass, whereas the ambient 'scary' noise makes the player feel as if they're a victim in a survival horror. That just not what Doom was supposed to be about.
However to give Doom 64 credit where it's due, I must say I like the redesigned enemy sprites much more in Doom 64, especially the Pain Elementals and Arachnotrons. See, it's possible to be creepy without taking the music in a different direction.