I personally think that was a nice touch
Rhode refused to accept that Dragons were wronged and vowed to never side with a dragon knight. At the end, All of Aleroth cheer as YOU the dragon save the divine and the whole city, so there are no need for dragon slayers anymore, maybe a new era of Peace and a time for new dragon knights.
Reminds me a little of the ending of "How to train your Dragon"