I've had similar experiences at work - I think some of it is the corporate world - pretty much being guaranteed a new position only to find out at the last minute that it was given to someone else. It's definitely disappointing! Don't stop pursuing other options because of this setback. I did and later regretted the missed opportunity.

Sorry you had to go through this!