With some digging around you can probably find an AOD transmission on the cheap. Granted there’s always a risk with a used unit but if the miles are fairly low then it’s worth a shot.
The last one I bought cost a whopping 75 bucks and it works like new.
As for not starting that’s difficult to say without hands on but the fuel injection/engine managment on these is pretty simple.
These cars also use the TFI-IV ignition module which is very prone to heat failure and especially so in the summer.