Your CSM didn't get to be an E-9 by being an idiot. He serves in that position "at the pleasure" of the Commander. If the "Old Man" thought he was out in left field, there would suddenly be a new face in that position. I've seen SgtMaj's retired/transfered in a heartbeat when they'd outlived their usefullness. It only takes one phone call from one Colonel to another Colonel at a higher HQ. It's not a common occurrance, but it does happen.
Generally speaking, the senior enlisted folks run any unit and handle all of the details. The officers handle the general direction of the unit.
Even down at the platoon level in the infantry, the Lt may be the one that says "Charge!", but the E-6/7 is the one that's already made sure that "The Lads" know what to do and have full bandoliers and canteens. The Lt may be "Out in front" (or near to it), but the Plt Sgt is behind the action where he can see everything that's gong on and can initiate corrective action if needed. It's a teamwork thing, each has his role. It's a smart Lt that figures out how to work with his PltSgt, and takes notice of his "suggestions and recommendations".
Been there, done that. I made E-9 in the Marines by always giving my CO's more than they expected...a lot of times more than they ever realized that they needed.