The issue isn't sex itself. It's putting a sex scene in most movies meant for adult audiences. Imagine if there had to be a shootout or extended martial arts fight in every romance movie or Hollywood just wouldn't fund it.
Use it where it makes sense, and leave it in the tool box when it doesn't.
It's fucking crazy to me that this is a hot take these days. I just want movies to be good. Throwing unnecessary sex scenes into a movie to drive ratings up usually does not achieve that.
Edit: And by unnecessary, I don't even mean just not plot relevant. Only that they should add to, not detract from, the characterization, tone, or plot/story. Fucking loved Challengers (check it out, it's great) and that had a sex scene like every 5 minutes. I just wanna watch some good fucking movies. If I wanted to watch good fucking-movies, I'd just find those online.