Here's a helpful new feature in the Content Calendar: hover over the red triangle next to the word Failed to see why a post failed.
This feature is especially helpful if you've turned off email notifications for post failures. It's also useful if you want to check why a post that another user scheduled has failed.