So, unfortunately the console and year are just guesses because this is not a game I played, but rather one I heard a review of I think a couple of years ago. Subsequently, because I didn't have any actual experience with the game, I don't remember a lot of details or know how much of the information I do remember is actually correct.
So I don't remember who the protagonist is, but, iirc, the the origin for the main antagonist is that she was a goddess (pretty sure it was a she) that was banished from her original pantheon and ended up in the land or world of the protagonist. Since no one there could communicate with her, they worshipped her as best they could, but since it was a different world with different practices and no way to find out what she wanted, she eventually went mad and they had to lock her away. I think the goal of the protagonist is to kill her because she's escaped(?) or is adversely affecting the area around her in some way.
Hopefully this will resonate with someone, because I honestly am not sure how much information I got correct or whether it's even enough to go on.