Grace Davie explores how cathedrals can be places to inspire a sense of belonging, where our aspirations for the Common Good find expression