The United Explorer Card is one of the best mid-tier airline cards, thanks to its perks and ability to earn bonus miles. Here's what to know before applying.