You’re adding Rotation. You will want to add location instead:
Above, you can right click pins and Split them to see their individual components, here XYZ.
Do note that the camera is still attached to the character so it may not work as you expect. It can be, optionally, detached by selecting the springarm in the component list and setting Location Type to World a.k.a. Absolute.
Then, rather than Adding Local Offset, you’d Add World Offset instead.