I think the "afraid to fail" goat and its opposite are more about people that don't get started because they fear failure. There's also a toxic version of being so afraid to fail that you cut corners, lie, cheat, steal, put others in danger, or take excessive risks to avoid failing even when the risks are high and reward low.