Those transmission had issues. lack of a 2nd gear oil jet if I remember correctly. Acurazine.com would have more definitive info on it - 2nd gen CL/TL section.
CL and TL used the same tranny. Not really sure on the type-s, think it may just be the shifter has manual mode that makes it a Type S, along with a few other upgrades besides the tranny shifter. 99% sure though they are the same.
You could use the automatic tranny from a 03-07 Accord, 04-06 Acura TL/TL-s, Honda Odyssey 02 thru ...? can't remember the cut off year, maybe 06/07. The bell housing is the same for all of those years so it will bolt right up to the J32A1/A2 block. Acura changed the bellhousing for their models in 07.
** The TCS and Immobilizer systems are different between the Honda and Acura. This will throw codes with a CEL and TCS light. You will lose TCS.
TCS is controlled by the multiplexor on Honda, controlled by the ECU on Acura. Honda uses the Type 4 immbolizer system, Acura Type 3.
So if you have emissions testing or Tech inspection, good luck.
Mechanically everything bolts right in. Electronically, that's another issue which I can't help you with. It's not 100% plug and play.
that's about all I have for ya....