Naturally, you do not hear people boasting about a failed TR course, but it is not an uncommon phenomenon.
Also, there are quite a few who don't get through the base check. In other words, they can't land the real aircraft.
I know of
AT LEAST 5 pilots who couldn't make the transition on to large multi crew aircraft, some on the TR some on the base check.