Hi,
Moving the camera is not going to be much of a zoom effect, you probably want to narrow the FoV to zoom.
The code you posted looks fine though, and should work.
Indeed, I just threw it on fresh third-person template project and it did.
Do you maybe have another Mouse Wheel Axis event somewhere that is consuming the input?