Yes, "stupid goat" would be the correct translation - even though I think no goat deserves being compared to such a person!

Kirsten