Not natively. The Wii's GameCube ports are disabled in Wii-mode titles—Black Ops only recognizes Wii Remote (+ Nunchuk), Classic Controller, or Classic Controller Pro.
Buy a Classic Controller Pro ($15–25 used). It feels like a GameCube controller, works natively, and supports every Wii/VC title.