any ideas how to get it shut?
Check the fuse first.
Many cars have a manual system to operate the sunroof in the event of electrical failure. Check the owner’s manual to see if your Cirrus has such a feature.
If it isn’t moving at all, check to see if the rocker switch is working.
If it keeps reversing itself, that would be the safety system activating. Clean the tracks.
My sunroof motor is working but it sounds like the gears are just clicking. How do they repair these things on a 97 Jeep Grand Cherokee?
It sounds like you need to replace the entire sunroof assembly. They’re not made to accomodate major repairs.