I have not played with this, but the difference is probably less dramatic than it sounds, however depending where your base is placed, it might cause incessant visits. Scouts on retaliation missions have a complex pattern which greatly raises the odds of them getting their tiny sightRange over your base. Also while they are going slow, they are more likely to proc a scan while your base is within sight. A random alien craft flying straight over your base at high speed will more often than not fail to proc a scan at the right time.
But mods can change their sightRange, and (OXCE only) you can also reduce their base detection odds by adding mindPower to the access lift facility (and correctly multiply the mindPower value for Mind Shield accordingly).
Default UFO sightRange is 268. In my mod I have set them to 600. I also set Access Lift mindPower to 2 and Mind Shield mindPower to 4. The end result is that aliens detecting your base is probably more akin to how most people thought it worked in the original game. It's far more predictable and far less dependent upon your base placement as to whether they will detect you immediately or can't detect you at all. With my settings, Aggressive Retaliation would probably make a much more significant but much more stable difference.
But again, I haven't used Aggressive Retaliation.