Ogling other women in sight of your wife is a serious sign of disrespect. Looking briefly is another thing. If you're staring in such a manner as to piss your SO off, you're probably ogling.
When I'm out with my wife, I don't harldly notice other women. I'm there with her and I'll make it a point not to stare at other women by purposely turning my back to hotties, etc... Not saying I don't notice a beautiful woman, that's obviously not true, but I'm in it for the long haul, so I will show her, and our relationship, respect.