Camera Snaps back after tween finished

I want the camera to tween to a location and stay there , but right now after the tween has ended the camera snaps back to the player

Code:

script.Parent.MouseButton1Click:connect(function()
local CurrentCamera = workspace.CurrentCamera
repeat wait()
	CurrentCamera.CameraType = Enum.CameraType.Scriptable
until CurrentCamera.CameraType == Enum.CameraType.Scriptable
local Part = workspace.Ring.TpEnd.Part1Camera
local TI = TweenInfo.new(5, Enum.EasingStyle.Quad, Enum.EasingDirection.In, 0) -- 5 = Duration, Style, Type, Repeat how many times
local Goal = {CFrame = Part.CFrame} -- Target Properties
local Animation = TweenService:Create(CurrentCamera, TI, Goal)
Animation:Play()
end)

Video (Sped up for post) robloxapp-20210106-0101053.wmv (544.4 KB)

Replace that with “local TI = TweenInfo.new(5, Enum.EasingStyle.Quad, Enum.EasingDirection.In) – 5 = Duration, Style, Type, Repeat how many times” instead, i think it’ll work.

it still snaps back to the player after the tween ended

delay(4.99, function()
CurrentCamera.CameraType = Enum.CameraType.Scriptable
end)