My understanding is officers usually aren't sacked for sex on duty/on police property/etc. However, I won't pretend it's an area of expertise for me.
Untennable-position wise, you make a good point.