No. A CCD camera is only as good as the telescope you put in front of it. CCD cameras by themselves are not capable of seeing much at all. It is very difficult to design telescopes that could actually 'see' a planet like Jupiter orbiting nearby stars, because the light from their star is diffracted so badly it hides the light reflected by the planet. CCDs would not do much at all to ameliorate this problem, but with the right kind of telescope in space, a CCD array would certainly be the preferred method for imaging the light, but it is the telescope that would be doing all the hard work.