Big things are happening on TV Tropes! New admins, new designs, fewer ads, mobile versions, beta testing opportunities, thematic discovery engine, fun trope tools and toys, and much more - Learn how to help here and discuss here.
The All American Pups series: Fritz, who freaks out at everything from the local cats to costumed humans. He's friendly and the other puppies like him (aside from some exasperation), but he tends to be thought of as the baby of the group.
Lemony Snicket himself in A Series of Unfortunate Events. In nearly every book, while narrating some terrifying situation, he comments that, had he been in the Beaudelaire's place, he would have been unable to go on and would have instead run away in terror, dissolved into helpless tears, etc.
To some extent, Fred Colon and Nobby Nobbs, though they've seen trouble before and usually square up to it if there's no other option, or Vimes needs them to do so. But mostly, "When the time came, he [Nobby] would not be found wanting. He would not be found at all."
"He had always thought heroes did heroic things for God and Country and mother's apple pie. He never thought they might did them because they might be yelled at if they didn't." (Actually, Colon isn't so concerned with being yelled at in that scene as with having Vetinari raise his eyebrow at him.)
In Castle in the Air, the sequel to Howl's Moving Castle, Sophie describes Howl as being cowardly (as well as sly and selfish and vain as a peacock). When Abdullah comments that she seems strangely proud of Howl's vices, she states that she's just describing him. (She does really love him, including his bad traits.)
Horace Slughorn of Harry Potter prefers to take the easy option over a direct confrontation with the enemy, but proves his inner bravery when he rallies reinforcements in Hogsmeade during the Battle of Hogwarts and leads the Slytherins into battle after previously evacuating them, not to mention going toe to toe with LORD FREAKING VOLDEMORT (albeit with the help of two other powerful wizards). And even before that, he's still a likeable guy.
Mundungus Fletcher's cowardice and dishonesty are generally played for laughs and he remains a member of the Order of the Phoenix in spite of them. There's never any implication that he would actively betray the good guys to Voldemort, it's just that he also can't be relied upon not to take off when danger looms.
Pierre Gringoire from The Hunchback of Notre Dame. He tries to do his best to help save Esmeralda, but when his own neck is at stake he decides he'd rather not.
Piglet of Winnie-the-Pooh is almost certainly this, a timid stammering Neat Freak who fears every superstition and mythical animal his friends make up. The Disney adapted version dials this Up to Eleven (along with adding Lumpy to the list as well).
The title character of the story "Philbert the Fearful" in The Practical Princess and Other Liberating Fairy Tales, whose Catch Phrase is "I'm the only one of me I have", and who is much more sympathetic than the other knights, all portrayed as Fearless Fools.