Is it possible to show CiviMails within our Drupal CMS system?
As you say in the question, you can build a View based on the CiviCRM Mailings tables so eg Body - HTML etc.

Alternatively you could build your mailing body in Drupal, then use a View based on that to drop a 'views token' in to your mailing.