I have definitely had my share of clams in a live setting. It never feels good to faceplant when people are listening (especially during a lead). My experience also suggests that most of the audience is clueless and hardly notices even egregious mistakes. It seems to happen that I get more compliments on my playing on those days where I know I blew it.
The flip side of that is also true. A few weeks back I had a good set. Afterwards I asked my wife how it sounded and she said that it was fine. She then proceeded to tell me that there was only one song where she
thought she heard electric guitar in a prominent role (wasn't even certain) and that it sounded good. There were prominent electric guitar parts in almost every song of that set.