From what I understand, when you shoot, the bullet "follows" the camera movement. This is because you are adding the bullet instance as a child of the camera. So when the camera moves or rotates, the bullet will do the same. Instead, bullet instances should be children of the current scene (which will not move/rotate). This make the bullet position independent of the camera movement or any other player movement.
So yes, the tutorial I linked should solve the issue