Lyric discussion by GrungyBeatle 

Cover art for Tension Is a Passing Note lyrics by Sixpence None the Richer

I believe it is about tension between a musician's lifestyle or the glamour of it and their relationship with God. Melody of You was written with King David in mind so it fits along the lines. This is my assumption.