Everyone knows the most interesting stories happen when you fail in D&D.
I'm sorry if I'm a bit blunt but that's a Larian's PR bull right there.
They were rambling on and on about making failure fun but I have yet to find one example of that. Like you said for yourself, failing in this game results in either combat or an option to succeed later (which is completely pointless)