These are precisely the types that do find work though as most airlines are not looking for misty eyed enthusiastic dreamers but properly trained, qualified individuals with a proportional level of professionalism and sadly, these days, the hard cash to self-fund a type-rating and maybe pay for the odd 500 hours worth of line experience. I have seen even the least gifted of students make it without too much effort to the right-hand seat of a number of European airlines (some sadly with nothing more than the social skills of an amoeba), largely because they were in the right place at the right time (or the right ATO) and the airline needed to fill seats on type-rating courses - it's all about market forces in this game. If you are good or even exceptional, perhaps you will find yourself in a training or standards role but ultimately, it's just a numbers game and when the time is right, the jobs are there. Now is the right time but two years from now...?
I wish you luck James - have you considered flying instructing?