I just looked up the Manfrotto 496. It has a 6 kg capacity. I think the C90 + camera weigh significantly less than that.
The moon (and bright planets) is bright enough to allow a small telescope on a camera tripod + ballhead. Let the ballhead slide down into the sideways notch, then connect the scope to the ballhead as close to the scope's center of gravity as possible (you don't need perfetc balance, just good enough so the scope doesn't move due to its own weight). The scope will be rotated 90 degrees; the bottom mounting plate will actually be on the side of the scope. To aim, pan the entire ballhead assembly for left/right, rotate the ball for up/down. You'll need to adjust the aim every few minutes as the moon moves across the sky. The moon is bright enough to use short exposures so there won't streaking in a single photographic exposure.
Some possible issues to watch for with the ballhead arrangement:
- I use a ballhead in the above manner with my Stellarvue refractor. That scope has a clamshell mount that's very easy to balance. I don't know the specifics of the C90 mounting plate.
- The scope will not be centered directly over your tripod because the ballhead is in the sideways slot. Tipping over might be a concern depending on how wide and stable your tripod is. Hang a bag or other weight from the center of the tripod to increase stability.
- I don't know whether the 496 ballhead allows easy panning. I use a Flashpoint F2 head from Adorama with my scope.
If you can't get your existing ballhead to work, maybe buy an altazimuth or panhead instead of a different ballhead. A ballhead can work with a light telescope but the other head types will probably be easier to use.
A tracking mount, a more expensive and complex option, slowly rotates the entire telescope to keep your target centered. It's helpful but not required for the moon and planets. Dim deep-sky objects that are tough to find in the sky and need long exposures greatly benefit from a tracking or go-to mount.