Has anyone made any sense of upgrades from Y to W or from W to J (when flying on partner metal, obv)?
It depends on the partner. AF you can only upgrade to W from Y and to J from W. Others allow you to upgrade from Y to J, but most don't allow upgrade rewards, only outright J awards.