Don’t take this as an actual character of O’Brian. He just had the unenviable position of minor character who commonly did the job most readily taken by ai. The other characters in these don’t escape flanderization for the sake of the joke. In this case Jordi also gets double dunked on for not only making out with holodeck maidens, but with O’Brians wife.
There's one story arc that implies this isn't the canon O'Brien, it's the O'Brien who, throughout the multiverse, happens to be the most depressed and pathetic.