When I think of fear of "success", I think of someone who doesn't want to bear the responsibilities/consequences that come with "success".
The reason why I put quotations on success is because it can mean different things to different people.
Is a loving father a success or a failure if he goes across the country for a job to support his family who he will rarely see? Not to me.