Why does my Add local Rotation node only work in the center of the sphere?

I’ve been working on making a camera system that is controlled by the players mouse drag. After multiple different versions I found that if I simply attach the constantly updating mouse location from a line trace into a Add Local Rotation node it had the outcome I want but it only works at the center of the sphere and clicking close to the center of the sphere snaps the camera to the center while clicking far away from the center sends the camera into a spin.

Here is a video of it happening:

Here is a copy of my blueprint:

Would appreciate any help on why the blueprint is acting that way and how I could go about having the mouse drag work all over the sphere.

See this post from @Everynone