Seems like a new arena isn't even necessary, considering the IOC themselves have come out and said the arena is fine. The main problem seems to be related to ski jumping, and the IOC has already suggested Whistler for those events.
Therefore, even if we get the olympics, I still wouldn't want to put a dime towards a new arena.
One angle I think people miss is that Calgary would be getting a bunch of funds from the provincial and Federal governments that would not otherwise be available. Calgary as a city can redirect most of this towards infrastructure projects. For the 2010 winter olympics, the Federal government gave Vancouver more than a billion dollars. The IOC is going to give about 900 million to the host city, which should just about cover the security costs. The provincial BC government paid about 1 billion in 2010.
So Calgary will have about 3 billion dollars coming it's way in funding - do the residents of Calgary really care if the Olympics lose money in this case? Security paid by IOC and billions of funding for infrastructure that might not be otherwise available.
And we don't even need a new arena or potentially any new facilities.
I think the case for Calgary's benefit becomes pretty clear throwing some of these numbers around. I can see why Edmonton (and, indeed, the rest of Canada) would throw a fit, since it will inevitably result in redirected provincial/Federal dollars, but Calgary stands to gain quite a bit IMO.