If there is one seat left on the flight, you will most likely have to buy the Y fare.

Y fares aren't so expensive because mileage upgrades cost less; the upgrades cost less because the fares are so expensive.