Yes, if your story is good you will get a playerbase.
My game, The DeLuca Family, has no sex in it nor is the story focused around anything related to porn. Most physical it got so far is groping and kissing (and one finger action). Yet, It is among the top-rated here and got a healthy playerbase.
In fact, right now I am working on lore writing (think of game of thrones lore story with timelines, important persons, important eras and events and different familie information and history. Just with mafia world instead and with an amateur writer instead of a world-class writer like George R.R Martin.)
So, as you can read, not a lot of that has anything to do with porn. Actually, today I made my most 'porn' like render ever. That was a request from a patron and it was a BJ render. I feel so dirty now.
So, yes, it is definitely possible to do what you want to do. But it is harder than doing it the 'normal' way. A porn game can get away with a lot. People are in it for some sexy time so they tend to skip anyway. But if the focus is the story, then it better be amazing. Not fine, good or great. Make it amazing.
One thing is to gather the attention of people who are in it for the story, it is a whole nother ballgame trying to gather the attention of people who are originally in it for the fap.
Of course, if you end up making it you will still get people who get annoyed at you for doing it your way (where da sex at?!).
Those are what we call entitled brats who think that all games have to be specifically made for them (none like them people). Anything that is not should be removed from the site. All my positive reviews are different, all my negative reviews are the same (lack of sex).
But even if they are loud- they are few and should be ignored. The danger is for a dev to actually get afraid and listens to 'em and change the game due to that. That is a big no-no.
I hope that helps it a bit. Always look forward to fellow story writers.
(And for the love of God, if you're going story route than don't make a mundane slice of life setting. It can work, but it has to be beyond amazing.)