WRT AFOQT only a couple sections are relevant for pilot accessions. But if indeed it is true he didn't even get the min component for a non-rated officer accession, yeah that's pretty bad.
The pilot composite only requires a combined 50 (25 on pilot, 25 on navigator), though those scores are generally considered non-competitive for an OTS pilot application.
Not all baby turtles make it to the ocean. It is what it is.