No. It's a cutscene event, and it won't return. You might as well ask to return to Lothering.
What you can do, however, is disable the DLC Warden's Keep. Load the game, save the game, and then enable the DLC again. Do it all over again, it will be reset, and the meteor cutscene will appear again.