It's the same kind of disconnect between story and "action" as something like Grand Theft Auto 4, where the main dude spends the whole time in a state of "I'm done with the killing, I'm trying to turn over a new leaf, etc." only to turn around and massacre hundreds of civilians as soon as the control is put back in the player's hands.
Yes and no, mostly no. This isn't GTA but even if it was at that level the main character in GTA is fully aware that they're a bad person.
Sophia's analog to that would be "am I a cheater" and she is written on the most cheating path (the path 99% play) with the mentality of someone that is faithful. This despite her:
Jacking off her son and taking his cum on her body, eating her daughter's pussy, jacking off her daughter's BFs buddy next to her daughter, making out with the same guy earlier at a club, making out with her son's best friend, letting her son's best friend suck her tits and take off her panties, playing with the little dicks of kids she teaches sex ed (for some reason), her son's bully at school molesting her in various ways, jacking off her friend's BF at the gym and taking his cum in her hand, etc.
The difference is that while the GTA protagonist wants to change while still committing crimes, they are aware of who they are and are written as such.
This dev's sole exit point of her endless sexual scenarios is the "snap back to reality" guilt trick that is 44 rungs BELOW the "it was all a dream" trope. It's dogshit writing.
So there is a massive difference while also understanding your general point.
*Edited to exit point from edit point autocorrect