Considering the taste for tabloid fervour across the English Channel, Ireland has something akin to a Gallic disinterest in our politicians’ private indiscretions, writes Clodagh Finn