Uncertain if the CX-5's antenna (from the 2013-2016) vintage is similar to your CX-9's, but in the workshop manual for the CX-5 the basic steps for removal and installation of the "center roof antenna" don't mention adhesive. Only a nut to be removed, to allow the antenna to lift up. I haven't needed to remove mine for fixing, so I'm uncertain if there is actually adhesive there. But the workshop manual doesn't indicate any.
So, perhaps the nut is simply loose and allow "play" in the antenna. A tight nut with very good threadlocker might be all that's needed.
FYI, for consideration during the effort.
Remove a bunch of panels and the headliner ...
6. Remove the nut.
7. While pressing the center roof antenna tabs in the direction of arrows (1) shown in the figure,
press the center roof antenna in the direction of arrow (2) to detach the center roof antenna
tabs from the body.
8. Remove the center roof antenna.
9. Install in the reverse order of removal.