Heavenly Bodies, the New York Met’s latest show, pairs the Catholic church with haute couture – and is set to be a sensation. The celebrated curator behind it explains why it all began in Blackburn