A heavy metal gig at York Minster has almost sold out – despite it causing controversy among some churchgoers.