I find the literal to be necessary - How does one assume that the War of Magog is yet to happen without requiring also that which follows it? Every word that YHWH has ever said will surely come to pass. HE declares that, not me. His words do not return to Him empty. Unless, of course, you claim that the Magog war has already happened somehow (Zeke 38)...
The reason it is a 'head-banger' is because of normalcy bias. It is outside of the paradigm that we all have been raised within - Rome still has tentacles deep in Protestantism - Hence the OP.
I may indeed have normalcy bias. The thought that God would ever be satisfied with blood sacrifice again is beyond my comprehension. These were types and shadows. They pointed to Christ and did all that was required of them and were fulfilled. As far as this one prophecy, remember they were still in captivity and broken as a nation. This was a 'pick me up" saying this is possible, and it was but did not happen. God gave conditional covenants that expired. Not from any lack on His part, though.