Sounds to me like you've got your concept of on and off around the other way.
There's some threads covering this already, but what little I remember from my auto cars is that turning overdrive off is akin to turning off your highest gear. And yes, the car does rev higher, shift later, etc etc.
You want overdrive on for economys sake.