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)