National Eucharistic Pilgrimage ends, but 'the best is yet to come'