Did some research into this, the root cause seems to be that CMO sets up a trigger_target_mask on the unit prototypes, which causes them to not pull from the defaults set in utility constants by Water Turrets since they are not nil at the end of the data stage.
A simple hotfix would be to insert the Water Turret masks into each unit's trigger_target_mask if CMO is detected.
Ideally, any mod that initializes the trigger_target_mask should take into account the defaults set in utility constants for maximum compatibility, so this is partially on CMO as well.