A very high volume Acura dealer told me they don't sell many manuals. Most people buy what's on the lot, which are usually autos. In my case, I had to wait 3 weeks for the car.
Since the CL isn't a high production vehicle like the RSX or MDX, the appeal for 6-speed cars should be pretty good when its time to sell it. Especially on sites like this.