I personally know a guy who failed his type ride twice, was released by the company and has now finished his probationary period at FedEx.
Just like everything else, it’s just one factor in many. During his FedEx interview, he owned up to it, said it was ALL his fault, didn’t try to lay blame on the system, the training, the instructors, etc; and was able to turn it into a positive experience by what he learned and how it actually made him a better aviator.
A 121 failure isn’t a good thing, but it’s not the end of the world or your 121 career.