Cardinal Philippe Barbarin welcomed his successful appeal, but said he would re-submit his resignation to Pope Francis