No. The kids aren't afraid of Marv (Daniel Stern) or Harry (Joe Pesci)—the burglars. They find their slapstick failures hilarious and entertaining.
While initially a bit nervous, the kids quickly see them as clumsy, outsmarted villains and enjoy watching Kevin's traps thwart them. The tone is amusement, not fear.