> Was Microsoft supposed to cancel the event at the last minute but still pay Sting his full fee that had already been contracted?

Yes, on both counts.

Optics matter, apparently enough so that we're talking about it right now.

Also, those aren't the only alternatives, but no matter how you spin it, what was done was not a good look.