Psalm 122 - Standing inside your gates

Many Psalms speak joyfully or longingly about specific places, so how do we read them in a culture not much concerned about location?

The idea of pilgrimage has been central to much of religious history, and yet is largely absent from protestant Christianity. Are we missing anything of importance? How might the idea apply to our own experience?