The pioneering video artist talks to Laura Gascoigne about mystery, compassion and sacrifice in art, as the first of his two altarpieces commissioned by St Paul’s Cathedral goes on permanent display.