Have done the same in the past on a whole fleet of buses, loctite works fine, use the medium or low strength stuff. Don't use the wicking variety, it sets so hard it's difficult to remove unless you apply a lot heat.
I am considering Loctite 222 for this.
In addition to the SMA unscrewing, I’d be a little worried about the effects of vibration on the transciever (e.g. solder joints on SMA jack cracking).
That would be my biggest concern for this application, especially as this is a very bulky antenna compared to the usual 1/4 wave stubs. Also the "hinge" near the SMA is likely to become loose.
I'm also worried about the hinge, so I think I won't place the antenna on a 45 degree angle. I'll either have it parallel or perpendicular to the SMA connector.
In addition to the SMA unscrewing, I’d be a little worried about the effects of vibration on the transciever (e.g. solder joints on SMA jack cracking).
Maybe you should get a unit vibration tested by a lab?
The unit itself is certified for vehicular applications, including shock and vibrations. Of course, I didn't do the certification, so I took it apart
I took it apart and the SMA connectors are screwed to the chassis using star locking washers. The enclosue is a extruded metal enclosure and the PCB is sloted into the enclosure, but between the PCB and the enclosure goes rubber piece that dampens vibration. The thing looks pretty solidly build. There is a massive chunk of metal that mounts on the PCB that serves as a heatsink and I imagine it also serves some type of mechanical function (it's really massive).
The WiFi SMA connectors are soldered to the board, but luckily I'll be using cables for those antennas.
I can post some pictures after the project is approved.