The game is extremely difficult, I even downloaded some kind of cheat menu with all these cheats turned on in the game
with max Courage, Charisma, Agility, Pathfinding. and I don't think really helped at all, the game eventually made it to the last day and the fairies basically killed people in a war and all the characters lived miserably ever after in doom and depressing gloom and then the game ends.
It also never lets the MC have sex with the main characters like Callie or Evelyn or Primrose etc. no matter what clue/card I present, also impossible to prove Primrose innocent and I literally did everything that was available in Library.
Thanks to the two people who tried to help, but this game is way beyond my novice game playing abilities.
This game is not your typical visual novel fap-fest, you need to use your brain and make considered choices. It is (IMO) well worth the effort. My guide has a big section at the end on finding the clues needed for secrets. And another section on wooing each of the women. The women in the game don't jump in the MC's bed for no reason - you have to make them like you, not just reveal their secrets and remove their inhibitions.
At the same time, though, this is not an RPG - maxing out skills does not really help all that much since the game is gated more to events than to your stats. Likewise money is pretty useless (you have no use whatsoever for more than about 110 or 120 coins). There are a few puzzles, and some of them are annoying, but that's what guides and asking for help on fora like this one are for.
You got one of the worst bad endings, the war happens if you don't ever visit the Fae court at all... which means you also completely missed a massive chunk of the game's content.
Keeping Primrose out of jail:
investigate the library 3x. Talk to P about what you found (modifies one of the clues). Then "present a clue" to Samarra for each of the things you've learned, and she tells you one more clue. With all that, you can reveal P's large ("guilty") secret. That secret lets you know that something happened in the library's back alley, so search there. Ask the crone about what you found. Go to Samarra and tell her everything you learned from P, from searching, and from the Crone, and P is cleared of suspicion. It's a lot of back and forth, but it's not "Lost Files of Sherlock Holmes" or Infocom-level difficult.