The term implies something that feels like "dodo" or imbecile.
Corvids and parrots and raptors are remarkably smart, yet not every bird species is. Some are incredibly stupid.
There's also the anecdote (maybe just in the American South?) of a chicken running around with its head cut off.
Also think of the "Always Sunny" meme where they call Dee a "bird" all the time [1]. It's meant to mean stupid, amongst other things.
That's from an anthropomorphized angle though? In their evolutionary niche, their level of expressed intelligence seems to be spot on, otherwise they'd have evolved or been outcompeted long ago.
In fact, some of those species that you might consider "incredibly stupid" may have existed long before humans and might easily outlive us if we follow some not-very-unlikely paths that we have opened up with technology and (lack of) social maturity. Who is "incredibly stupid" then?