A lot of people use the term in different ways so I don't think there's a universal answer to this, but I can answer for the way I use the term

For me, a narrative game is a game where players are expected to interact directly with the narrative/story, rather than indirectly through in-game actions