Your question is hard to read. I am assuming you are at the point where you decide if the "game" you are going to create will be considered eroge or not. And it seems that you will not have any gameplay, but only story. That is basically writing a novel.
How do I say this. Well, ever heard of Fifty Shades of Grey (the book)? Immensly popular and successful adult book. Does this mean, all adult books are successful? Of course not. Does this mean the same story would be more successful, if it were spiced up with more adult things? Depends on your audience and the story.
You will get some cheap views for having an adult visual novel. But without substance, it might not get popular. And if you have substance, it might also have gotten popular without the adult things.
Normally I would say, know your audience. But since you do not have an audience yet, I say, know yourself. So in my opinion you should write whatever you have the most fun in creating. And if you feel your story needs more (or less) adult content, you will also know if you should aim for an eroge or not.