I have been faced with the same circumstances described by the OP.
When I pressed the point that advertising the upgrade sale meant that there was availability, the desk clerk asserted that there was no availability and that the website was designed to oversell, assuming there would be some no shows.