They make CX's with automatics? :dunno:

I didn't think that motor made enough power to circulate automatic transmission fluid. Sorry I'm not more help. I'd be more inclined to think something's rattling or rubbing than something actually knocking inside the engine. Maybe check out your exhaust?