I can not answer the de-rated question. I can only suspect that you can better torque manage with the auto, the same thing that GM has done for years with their trucks, the manual version is derated. And I think now GM does not even offer the manual anymore for for the new body style. I just went to their website and a manual trans is not even listed as an option anymore, just the new 6spd auto for the 6. 0L gas and Allison 1000 6spd for the 6. 6L D-max.
But I can tell you that, yes, the CC only gets the 6sp Aisin auto.
The pick-up trucks get the new 68RFE which is a 6sp auto as well.