Gorons are not stupid, no, although there is a social stigma of them being not as refined or 'intellectual' as some of the other races. It has more to do with their manner, specialized minds and such. Stereotypes are held really strongly by most people in this setting, though.