I think if we get into this, we'd be squabbling over the definition of the term "pathetic". From my definition of what it means to be "a bit pathetic", that's okay and also desirable, because it makes the character relatable. Harry being almost OCD-like chivalrous to women (even if they don't want it), not being able to pay his rent on time as a permanent state of his life up until the point of the first three books and being looked down by "real cops" for what they perceive to be a con man is all what I would personally view as being "a little pathetic". That is off-set a LOT by his other personality traits (loyalty, bravery, sense of humor, deductive power), his powers as a wizard and being a genuine badass when it counts.
For me, Harry being not perfect and having a few little pathetic traits mark him as a human being I have a much easier time engaging with than some hero without flaws. Contrary to Grimsby, who is such a woobie most of the time that it takes me somewhat out of the story and I have problems sympathizing with his problems because of that.