That’s the most common useage these days but is a backronym. “Going Ham” has been a term for long before that song – I grew up with it in Western Canada in the 80s and it absolutely just meant “going berserk or out of control with/on”