as it is currently the object gets attached to the character to its location is determined by the characters location. if you want the object to move relative to the camera then you would need to attach the object to the camera. or you would need to create a script which moves the object based on the control rotation of the camera.