Vatican diplomat seen as second only to the pope insists Saturday’s referendum result shows ‘the church must strengthen its commitment to evangelisation’