I honestly don't know jack about the old D&D Creature Catalog. The Gyerian sounds goof as frig, but whenever Wyatt starts talking about how stupid something is, I remember he's the guy that said D&D wasn't about traipsing through fairy rings and that talking to guards isn't the fun part of the game and I remember that James Wyatt clearly doesn't play the same kind of D&D that I enjoy. I could see the critters he describes as comic relief; more generally, I can see chicken-like critters related to ideas of the phoenix and the sun and the mythic resonance of the rooster. That's not what those critters are from his description -- pure comic relief -- but I honestly don't really trust Wyatt's view on what's fun for me in my games.
The nagpa sound kind of awesome....the cursed angle and the vulture visage is really cool. He describes them well; I'm into 'em.
The kenku/tengu distinction is something I end up agreeing with Wyatt about, here: they should be separate, with the thieving kenku as dirty little bird-rogues, and the tengu as the avian samurai. I would have no problems lumping Dire Corbies into this group, either; they seem to share some of the traits of both.
I'm not a fan of raptorians. The "make a pact with something" angle is trite, and the obvious "we have a mechanical niche, quickly, make a new race!" is obvious in them. They don't earn their place very easily, and their mechanical niche is something I disagree with: 1st-level flight is not inherently a problem in a game, any more than 1st-level teleportation is.
Aarakocra I like. Rather than a pact for control, I see them working with air elementals as allies and kindred, not master/servant. They're tribal and tense. They're ready-made for a good Interaction challenge in making peace with them, or in using them as allies. I also tend to think that they can be adventurers just like hobittesque halflings can: just because MOST of your race freaks out at the idea of being underground doesn't mean your character has to.
Lets just bite the bullet and allow aarakocra PC's that aren't super claustrophobic, but also aren't formed from a bond with air spirits. If 5e is fragile enough to break with flying PC's, it's too fragile to work for a variety of games.
If the raptorians can add anything beyond "flying PC!" to the mix, lets work with that. Maybe rather than a race, they can be a prestige class for elemental warlocks, or an organization of flying shamans, or something more distinct. They need to find their own reason for existing, and "FLYING PC, GUYS!" is not enough of a justification, because avariel, dragonborn, aasimar, deva, tiefling, pixie, the fly spell, etc....
As for the broader world context: lets stop swearing pacts to things, okay?! This is not a compelling hook for everything (*cough*Minotaur*cough*). Why can't bird people just fly without having to invoke magical air spirits? They're bird people, can't it be something they just do? Can't Dire Corbies be crazy little bird people of the underworld, without having to be linked to Pazuzu? It's like whenever the designers are out of ideas, they're like "lets have it swear a pact to something!" and/or "Lets make it a fey!"
Want these guys to get used more? Lets try something a little more authentic and a little less "throwing crap against the wall."
Aarkocra: Become a PC race, decrease the severity of the claustrophobia at least for PCs, they fly naturally. They're also friends with air spirits -- allies, not sworn servants. Sure, they can be friends with djinn, why not, but lets not have it define them to the point of hating fire, mokay?
Raptorians: Become a PC option -- a prestige class, organization, specialty, or somesuch. They learn to fly over time, and ARE the sworn servants of air spirits. They are how normal people learn to fly. Their 3e backstory becomes the story of how 5e PC's become one. These guys can maybe hate on efreet, they're already mentioned as being warriors for the air elementals.
Kenku: PC race of tricksy crow-people. There's a lot of weight in that archetype, all urban grit and survivalism. Make them a large population in a big city, and it should connect them well.
Tengu: Monster. Supernatural bird-samurai. Keep 'em mythic. There's a potential for these guys to be fey-related, too.
Dire Corby: Monster. One of the bizarre hoards of the Underdark. Keep 'em simple and weird and chaotic and animalistic. Meeting these guys should be like something out of Hitchcock, all beady eyes and blood-soaked beaks, black feathers boiling out of bolt-holes with echoing croaking cawing noises and the screams of your companions.