A Disappointment
A disappointment is someone who thinks they're a total disaster but they're not. They mess up all the time but that's fine because everyone messes up. Don't let anyone tell you otherwise.
My cousin failed his math test but he still thinks he's the worst human ever.
My dog peed on the carpet again but he's still my favorite dog.
My ex got a D in chemistry but she still thinks she's a failure.