Straight guy here. I’d imagine the sex drive wouldn’t change, but the only change would be who that person is attracted to. If you’re with a partner who knows what they’re doing, sex is going to be wonderful. And if it’s part of a healthy relationship, it can deepen bonds and emotional intimacy more than hooking up could.