My understanding is that the dragon-riding happens near the end of the main quest, but that you can then summon the dragon back in Skyrim. I'm glad I'm on pc because this will likely be much improved with SKSE.