Maybe a stupid question, but is “sordid affair” about how much two married people in an affair want each other?

See title.