The narrative is based on the result of the criteria of the analysis, if you set your sorting there, the narrative will adapt and follow.

But when you play with sorting at the table level, that's just the table itself, it isn't the analysis sorting, so the narrative has no way to know about it as well as the rest of the analysis doesn't know about it.

Set the sort on the criteria tab and the narrative will display the same as the table view.