So your camera is following the vehicle, but your camera is setting a custom rotation, so even when the vehicle turns, the camera maintains its custom rotation. To have it follow the car you will have to reset the camera back to the front of the vehicle.