No, you cannot throw fireballs in Tony Hawk's Underground on the GameCube (or any other platform). The ability to throw fireballs is not a feature in the game. The game focuses entirely on skateboarding mechanics, tricks, and customization, not magical abilities. You might be thinking of a different game entirely.