There's never been an AOD or AOD-E behind a 2.3L OHC. If you want overdrive your looking for an A4LD. It's basically a C3 with overdrive. It ain't much and it's not something I'd consider for a performance application, but it'll deal with the day to day family commute. You can find them in 4 cyl. Mustangs and Thunderbirds. They were found in the ARB line (Aerostar, Ranger, Bronco II) but I believe the tailshafts may be different therefore making overall length different which rules them out for bolt up swaps.
A more durable, non-overdrive
trans would be a C4. You'll need to either find one with the right bellhousing or find a bellhousing separately. They pop up on e-bay periodically.
The last alternative would be to swap in the T5 and tell everyone in the house to "man up".

: D