John Terry is the latest celebrity to be pilloried for his alleged infidelity. But, says the author of a new book on couples, if we judge public figures too harshly, it is our own private lives that will suffer