To the OP, I do astrology for people and fear of failure does come up reasonably often, but what comes up far more is fear of sucess...
People (not sure if this translates into US culture), are affraid to be all they can be. It ultimately leaves people with a gap between where they are and where they can be.
I think the fear of failure or suscess is more often experience by bright people.... IE people who have a lot of potential - ie their potential is so big its daunting.
There was a love quote someone sent me from a dating site, when guys tend to pick low hanging fruit rather than aim for women they ought to be with.... it was sweet and there may be a nuget of truth in it, I don't know - settling for less isn't something I relate easily too.