It would be treated like religious beliefs are treated in the most successful secular societies. It would be personal, not public. I think promiscuity is fine so long as you use protection. One thing I hope would diminish is any attempt to separate emotion from sex. "Purely physical" isn't something I consider healthy. Surely even a one-off encounter doesn't have to lack affection or honesty? Then again I think the number of loveless marriages shows that's I'm being naive.
The fact that a believer is happier than a skeptic is no more to the point than that a drunken man is happier than a sober one. ~ George Bernard Shaw