Dean of Brisbane Peter Catt has stepped down from his role after allowing a controversial reality TV show to be filmed inside St Johns Cathedral.