I agree with you that the language is metaphorical and apocalyptic, but that does not mean that it can be ignored or that it can be made to mean the very opposite of what it rather obviously does.
Zechariah 14:1 Behold, the day of the LORD cometh, and thy spoil shall be divided in the midst of thee.
2 For I will gather all nations against Jerusalem to battle; and the city shall be taken, and the houses rifled, and the women ravished; and half of the city shall go forth into captivity, and the residue of the people shall not be cut off from the city.
3 Then shall the LORD go forth, and fight against those nations, as when he fought in the day of battle.
4 And his feet shall stand in that day upon the mount of Olives, which is before Jerusalem on the east, and the mount of Olives shall cleave in the midst thereof toward the east and toward the west, and there shall be a very great valley; and half of the mountain shall remove toward the north, and half of it toward the south.
The 'nations,' which must surely mean Gentiles, are coming against Jerusalem, and the Lord is going to fight against them. Half the city will be taken, and half not taken. I think that's pretty clear, leaving aside verse 4 which perhaps is more difficult..
How does this work in relation to AD 70? Correct me if I'm wrong, but didn't the Gentiles win and take the whole city?
Zechariah has a context - he & Haggai were raised up about 20 years after the temple rebuilding had been started & discontinued.
They are encouraging the Israelites, led by Zerubbabel & Joshua to get on with the rebuilding - ultimately for Messiah, according to Gabriel's prophecy in Dan. 9.
Many of Zechariah's prophecies are specific for the last week of our Lord's life on earth & the response to the Apostolic preaching:
Zec. 3:9, 6:12-13, 9:9, 11:13, 12:10, 13:1,6,7,
So, how do we understand/interpret Rev. 14 in that context?
The Israelites, in rejecting & crucifying their Messiah have broken the covenant. They looked on the pierced One & mocked him. Now they MUST look on him in repentance & be baptised in the opened fountain. Acts 2 records Peter's preaching & the response of 3000. Acts 3 confirms that Jesus fulfills the covenant, & warns his hearers:
22 For Moses truly said unto the fathers, A prophet shall the Lord your God raise up unto you of your brethren, like unto me; him shall ye hear in all things whatsoever he shall say unto you. 23 And it shall come to pass, that every soul, which will not hear that prophet, shall be destroyed from among the people.
The Jews were becoming non-covenant people. Stephen, by the Holy Spirit, declares them 'uncircumcised.' They are the first nation to be destroyed.
There is a new prophetic Jerusalem being built, a new living temple, a new people of God who according to Zechariah:
13:9 And I will bring the third part through the fire, and will refine them as silver is refined, and will try them as gold is tried: they shall call on my name, and I will hear them: I will say, It is my people: and they shall say, The LORD is my God.
14:8 ...
living waters.... must relate to the outpouring of the Holy Spirit according to Jesus' prophecy.
The war against Jerusalem should be understood as war against the new Jerusalem, the redeemed people of God - Christians - and the Jewish leaders, now declared 'uncircumcised' are in the forefront of that war, determined to exterminate the followers of their Messiah.
14:4,5 prophesy the flight of believers from the city. God opens the way, & guards them as they flee. And in v. 9 -
And the LORD shall be king over all the earth: in that day shall there be one LORD, and his name one.
There is no longer a rival city, rival temple, of godless people claiming to be chosen. Jesus is fully vindicated - our LORD Jesus Christ.
Hallelujah!