With his second album, ‘The Sinister Urge,’ Rob Zombie upped the ante, unleashing the closest thing he has to a straight-up party record.