From what I know, (I'm Australian so it's used a lot in our lexicon) it just means to be very silly or foolish. I don't see where the connection to intelligence levels come from.

I hope it's not ableist, cause I love that word. My Mum and I use it all the time when the cat does something silly.