The song in the boathouse episode is "The Ballad of Lucy Jordan" by Marianne Faithfull.
Poignant and melancholic, it underscores Lois's sadness and isolation after arguing with Hal while looking at the lake.