Yowie. Yowie can mean an expression said when someone hurts themselves (said instead of profanity) but it can also mean an legendary apelike creature from Australia. Yowie.
This song is called "yowie" because the guy in the song repetitively says "yowie." Also because, why not? BeepBox for "yowie" sound (and the other sounds including one called mosquito. huh.)