The data on failure in games is extraordinarily rich. It's, after all, one of the defining features of games.

Players like failing. At least, they like specific types of failure. "Although players do not want to fail, they may nevertheless enjoy it when feeling responsible for it."