"Honky Cat" and "Goodbye Yellow Brick Road" are about the same person.
"Honky Cat" is the naive Country Mouse who's idealistically left his (or her) boring country life behind for the excitement and glamour of the big city ("I quit those days and my redneck ways / Oh! Change is gonna do me good!"), and laughs off the warnings he gets from his fellow country dwellers ("and all the fools back home, well, said I was a fool").
Unfortunately, by the time "Goodbye Yellow Brick Road" comes around, our Country Mouse has learnt the hard way that the big city isn't everything he'd hoped it was, he's been the trophy lover of a wealthy man or woman and it's soured, ("You know you can't hold me forever / I didn't sign up for you"), he ends up bitterly regretting his decision ("should have stayed on the farm / should have listened to my old man") and, disillusioned, resolves to move back home ("I've finally decided my future lies / beyond the Yellow Brick Road").
"Take Me to the Pilot" is about The Prisoner (1967)
The opening lines are, "If you feel/ That it's real/ I'm on trial/ and I'm here in your prison." (This implies not only Number Six's situation, but questions about the reality of the experience itself.) The references to "through a glass eye" can refer to the cameras in various places, the all-seeing eye in "Free For All", or Number One's crystal ball in "Fall Out". The chorus of "Take me to the pilot" can both refer to seeking Number One, or actual times where Number Six was taken in a plane ("Many Happy Returns", "The Schizoid Man"). The line, "he may be she" can refer to the position of Number Two, especially in "Free For All." Finally, if one believes that Number One is Number Six's ego, the line "Take me to the pilot of your soul", takes on a new meaning.