This is an old question, usually asked by those who fear hedonism. Reality is always much stranger.
We've all heard that, if you put a rat in a cage and offer them food, water, and heroin, that they will prioritize the heroin until they die. Many people have extrapolated this into the idea that you need to keep heroin out of people's cages.
Rarely is it suggested that the problem might be the cages. As it turns out, if you give rats a choice between food, water, heroin, and social interaction, they will prioritize social interaction.
You can further generalize this to identify that scarcity creates popularity. For instance...
- When the US illegalized alcohol, it created a boom in the underground alcohol business. The number of bars in New York, pre-prohibition, was about 800. After prohibition, the count of speakeasies was around 2000.
- When we illegalized marijuana in 1935, it was a small problem on the south border that mostly involved immigrants and jazz musicians. Today roughly a third of the US smokes pot every now and then.
- After Colorado legalized marijuana, our high-schoolers reported that it was an old people drug. Auto accident comment removed as per @AncientGiantPottedPlant's input
- Between the passing of the Controlled Substance Act in 1970 and 1990, cocaine use in the US tripled.
- As another anecdotal point, if you talk to "exotic dancers" across the US, you find that the raunchiest strip clubs (and highest paying) can usually be found across the border from high regulation areas.
- Extreme kinks are correlated to high-stress occupations and parental issues, not having too much free time on your hands.
Let's face it, jobs are a cage. They restrict our time from the things we really want to be doing, and they actually increase the probability that we'll want to perform high-intensity behaviors in our free time.
But we have other cages we can put people in. Social retribution is a common one. When Portugal decriminalized drug use, the drug use didn't drop, but the bad side effects like death, addiction, disease, unemployment, and incarceration all dropped significantly. This had nothing to do with availability of free time.
So, let me ask, if you had unlimited free time and no artificial social restrictions, would you spend it all doing drugs and having sex? If not, why do you think that everyone else would?
Addendum:
Yes, some people will go that way. Some people need board games in order to effectively socialize, some need sports, some need to be passing the peace pipe to be comfortable with those around them. The point is that post-scarcity won't increase this behavior, and there are factors that suggest it will decrease.
The most poignant detail is that, for those who do stay at home and do drugs or go to orgies, it will have zero impact on their ability to contribute to society. In today's society, such behaviors would take them out of the workforce. In a world where nobody needs to work, that isn't an issue.
Maslow's hierarchy of needs has a couple of layers above biological needs and security that are all about achieving social acceptance and significance. You can't do that by laying around at home. When people spend less of their time digging in the dirt, they have more time to do the things that are important to someone besides the shareholders.