Helldritch
Hero
If you talk about the players and not the game. It is a drama in a football game. It is not a story about a football game. It becomes a story about football players, and that story I would read. But a story about the game would pretty much limit itself to which player did a touch down, how many verges were made in each attempts, who intercepted whom and yaddi yadda. Again, booooring.I don't think that's really true, though. One could easily write a dramatic story of a football game.
You would focus on at least a couple of players, and write about their internal thoughts and feelings. You'd contextualize the struggle of this particular game within the context of, for example, the league standings, any historical rivalry between the teams, any reasons for grudges among the players (did Ronaldo get a red card for fouling McKesson last time these two teams met? Is McKesson looking for revenge?), etc. The basic elements of drama are there, and are many of the same ones announcers use to hype up the game and increase excitement and audience engagement.
I do think RPGs lend themselves a bit more easily to being converted into a dramatic story, but that's in part because of the subject matter; our characters are usually participating in scenarios based on either pulp adventure stories or epic fantasies.
Of course, a dry retelling of an RPG game session focusing on the mechanical details of combat would be no more intesting a tale than a recap of a football game that just focused on the scores and key statistics.
A role playing game will not limit itself to rolled dice as characters's motivations are integrated into the game. It is a role playing game and though a full recap of who rolled what against whom or what would be pretty boring, the telling of characters interactions with their enemies and their friends could and would lend themselves perfectly in a novel. As the results of dice are not numerical value but become hits and misses with different effects and results. Even the characters' speech can transfert into a nice narrative.
This is not the case with football.