I used to argue about the interpretation of the prophecy with other fans for years before I finally came upon an epiphany one day.

It doesn’t matter what it means, because even the Jedi don’t know for sure.

Yoda even admits that the prophecy may have been misread.

So every interpretation of the prophecy from “Destruction of the Sith” to “Equal number of Jedi and Sith” (the “official” canon answer and the oft-cited fanon answer respectively) to the much less common “The prophecy isn’t real/is a lie” and “The prophecy is real but Anakin/Luke/Rey were not the Chosen One” are all equally valid, IMO.

The movie gave you room to believe whatever you want to believe. Certainly, George made it clear what the Jedi themselves think - that the prophecy is real, that it means complete destruction of the Sith forever, and that Anakin probably isn’t the chosen one but they were willing to leave the door open for that one…