I would like to answer to this, because I disagree, but with zero intention to start a fight. It's just that certain points you raise in this post seemed interesting to me and I want to examine them a little.
So first of all, your main point is that Rhaenyra does not deserve to be Queen of the Seven Kingdoms and the fact that she's the rightful heir doesn't legitimise her by itself, since she became a tyrant. Ok, I can entertain this argument. You say (along with many other fans, that's not exactly directed to you because it is a very popular opinion) that the point of the story is to show the inherent pathology of House Targaryen. So according to that idea, GRRM intended, both in Fire and Blood and in ASOIAF, to show the House Targaryen as a Shakespearean (Macbeth style) bloodthirsty, immoral, ruthless family, obsessed with power and murder and the supremacy of their blood, and it is precisely that element that destroyed it. You also add that this ressembles the fall of big european monarchies in Europe of 1700's, a fall that you attribute to the growing selfishness of the European Kings. Then you imply that people who chose a team are simplistic and cannot catch "a sophisticated metaphor which investigates the natural tension of the human being to always strive upwards and desire more than one already possesses while partecipating in the construction of a society based on selfishly abusing the other to fulfill personal goals", which is a lot of words for simply saying that everybody is bad in the story because all the characters are basically aristocrats so they are basically bad by definition.
Except that, you say all that for Rhaenyra. You don't say that for the Greens. You apply that specifically to Rhaenyra. You don't choose a team, you admit that Rhaenyra is the rightful heir, and then you say that she shouln't be Queen and that her greed for power destroyed the realm. Her greed, because this post is talking about her. This is interesting. I don't doubt that you recognize that the Greens share similar flaws, but still, you didn't choose to write a long meta to delegitimize their claim. You chose Rhaenyra, because Rhaenyra and her fans claim the moral superiority in this war, and because Rhaenyra's line survives, and because Rhaenyra represents the House Targaryen in this story, and House Targaryen is the favourite house of the vast majority of the fanbase.
So two points, one general and one specific for Fire and Blood. If you believe GRRM wants to present the House Targaryen as an analogy for Macbeth, it is natural that you see them as a bunch of blood thirsty amoral ambitious tyrans obsessed with magic. The problem is that this is not how GRRM wants to present the house, this is not how he presents the house, this is not at all the general message of his stories. The Targaryens are the greatest dynasty in ASOIAF. They disappeared with Aerys, and that was a very low point for them, but they were reborn with Daenerys, who is, in all sorts and purposes, kind of the protagonist of the story along with Jon Snow. The entire point of her character is that she's supposed to use this magic to save the world from the eternal Winter. So magic is an essential element in this story. It's not that the Targaryens are "obsessed with their magic", their magic is an essential, central and extremely useful element that is painted in a positive light. Their magic is pretty much the only hope people have to survive. So, this interpretation of Targaryen magic as this sinister analogy for power, despite its popularity, is fundamentally mistaken. This goes directly against what GRRM wrote in the first sentences of his first book, that's how fundamental this point is. It is literally the basis of the story.
Second point, specific for Fire and Blood. Fire and Blood is more of a tragedy, ASOIAF has more heroic and epic aspects to it. Daenerys is destined to save the world from the Long Night, while Rhaenyra is destined to become a tyrant, so there are not many analogies to be made here. So let's talk about Rhaenyra. She became a tyrant yes. But why? Who made her that way? Was she born a tyrant? Was she born a blood thirsty monster? Was that her goal since the beginning to just murder everyone, execute her people and steal their money? Or she became that way, as a reaction to very specific incidents, provoked by very specific people for very specific reasons? Any "sophisticated" analysis that does not examine the core reason for the Dance, (Westeros' misogyny and the green's treason followed by the greens kinslaying) is incomplete. It is also extremely biased, whether that was intended or not. No Rhaenyra wasn't born a blood thirsty monster because she's a Targ. Rhaenyra got dragged into a war because the Greens decided, in an ultimate display of greed, ambition, selfishness and misogyny, that she is not fit to rule, since the very moment she was named heir. They also murdered her child. So, attributing the war to the "Targaryen superiority complex" (which Targaryen?) is all nice and very convenient, but it is not what happened. Helaena's quote is also nice, except that it refers to the greens, not Rhaenyra. So it does not really apply here.
Last observation. You mention the European Kings and how their growing "selfishness" led to their doom in the 1700's, except that's not what happened either. First of all, not all European authoritarian rulers fell in the 1700's. Actually, the majority didn't, or they fell and later they were reestablished, even more gloriously. Catherine the Great (I consider Russia Europe but ok) ruled in the 1700s and it was the greatest period of the Russian Empire, both for Russia's place in international politics and for the people. Also, it is quite simplistic and also not accurate to attribute the fall of monarchies to the growing selfishness of the Kings. The reasons are much more complicated. Monarchs were not inherently bad because they are monarchs. There were great and inspiring monarchs in history.