What am I doing wrong?
Nothing. You are just not considering, that AE has no contiguous/ consistent 3D space and each effect, no matter how 3D it may look, exists only within its limited universe inside the layer just like CC Sphere does. It does not interact with AE's 3D space. Therefore you will have to fake it by e.g. applying a circle as a track matte to your text and using duplicates. The simplestr way would be to again use CC Sphere also for the text and make use of the rendering modes - one instance that only renders the outside on top of the planet, one below the planed set to render the inside.
Well I didn't understand everything you wrote but managed to get enough from your response to correct the problem. I used CC Sphere instead of cylinder and chose "Outside" for render. That worked. Thank you
I finished my project and uploaded it and wanted to share.............