You have to look up an old "seamless texture" tutorial. Doesn't even matter whether it's specifically for AE, Photoshop or a 3D program. The basig drill is to create the texture, then offset it e.g. with a transform or Motion Tile effect and then patch up the seam that appears where the two edges meet with an extra duplicate layer on top that is masked, some blurs or whatever is the best way. Then you would un-offset the texture back to its original coordinates by applying another transform effect with inverse values, but this may not be necessary for CC Sphere. Same for the pole caps and other artifacts you may get. It's all just a bit of illusion painting and applying some oldschool tricks.