Sex scenes can absolutely feed a narrative purpose, like in Game of Thrones where it’s almost always a political motivation or has a greater meaning to it. However, if I wanted to watch two people have sex, I would go to a different site to watch it/wouldn’t go to a movie theater for it.

People aren’t upset about sex scenes, they’re upset about unnecessary ones.