They're people like anyone else. As Cory says, it's the children's viewpoint which is important.
It happened at a school near here; very evangelical born again head, had an affair with deputy; the kids all knew, some parents felt there should be resignations the ex husband wept to other parents.
All settled now; they're living together, everyone's happy. The only thing that bugged me was that she is a very evangelical disapproving born again....but, hey, everyone's fallible