I think that episode points out explicitly that the Enterprise-D was never meant to be a 'warship'.
It was definitely meant to be the sector command ship. And was on the frontline at Galorndon Core. I'd rather have a dick in the captain's chair that is interested in actually surviving the battle.