A dragon is very much the equivalent of a nuclear warhead. The only reason the Targaryen’s were in charge in the first place was because they had dragons at their disposal. After they went extinct, it was only a matter of time before the other houses got sick of the Targaryen’s, i.e., Robert’s rebellion against the Mad King

1