I just wanted to comment and say thank you on this one. My Edge STs never would go into 8th gear in Sport mode, but tinkering around showed me that I thought the Explorer does go into 10th. Never thought of hitting the manual button... DOH!
Anyway, it behaves like my Mustang GT in Sport with the 10R80; it'll climb into 10th gear and settle down at higher speeds. I always thought it was really dumb that once you set the cruise for Sport, you couldn't go into the final drive on the Edge unless reverting to Normal.
Sport is an excellent mode for city driving and on ramps, etc...