I suspect that the term "Zion" only has triumphalist connotations for most Western Christians today for two reasons:
 
(i)   Because "success" is their supreme goal... (idol?).
 
(ii)     Because of its association with contemporary "Zionism", and its   connection with the current State of Israel's "success" story.
 
Both   expectations are to end in disappointment and disillusionment.  The   Church is not going to be triumphantly "raptured" prior to the time of   great tribulation; nor is it going to succeed and take "dominion" over   the whole earth immediately before the 2nd Coming.
 
The Church,   along with Israel (people, nation and State), is going to plunge into   the depths of the profoundest turmoil, adversity and difficulty, to   there be chastened, preserved and finally rescued by our Lord Jesus   Christ.  He will return to a Zion made barren by and in His   absence...but transformed by His presence into the earth's most exalted   and beautiful city.
 
Any eschatology which rests on any other hope is false (a deception), and therefore will prove to be worse than no hope at all.
 
Until   The King returns, Zion will be "barren"; by the eve of The Day it will   have become a "desert"...along with most of the Middle East!  But when   He is enthroned, Zion will again be "David's fortress"...a place of   utmost triumph and glory.
 
Why is it that the Church arrogantly   persists in its totally selfish belief and expectation, that it will   enter into its glory before The King enters into His? Such a view   beggars belief ,and betrays a modern "gospel" which is all about our   reward, and not at all about His!
 
"His holy mountain, beautiful   in elevation, is the joy of all the earth.  Mount Zion, in the far   north, the city of the great King."  (Ps 48.2)
 
"It shall come to   pass in the latter days that the mountain of the house of the Lord   shall be established as the highest of the mountains, and shall be   raised up above the hills; and peoples shall flow to it..."  (Mic 4.1)
 
"On   that day it shall be said to Jerusalem: 'Do not fear, O Zion; let not   your hands grow weak.  The Lord, your God, is in your midst, a warrior   who gives victory; he will rejoice over you with gladness, he will  renew  you in his love; he will exult over you with loud singing as on a  day  of festival.' "  (Zep 3.16-18)
 
