Why does my camera script using CFrame not work when I test it out?

I recently learned how to move cameras with TheDevKing but he didn't explain how to move a camera using CFrame so I tried to do it myself with the help of the roblox DevHub but it didn't work. Is there any error in my script that I need to change? The output showed no error. Thank you in advance.

Script:

local cam = game.Workspace.CurrentCamera

local pos = Vector3.new(0, 100, 0)
local lookAt = Vector3.new(100, 0, 0)
local CameraCFrame = CFrame.new(pos, lookAt)
cam.CFrame = CameraCFrame

Set the camera type to scriptable.

cam.CameraType = Enum.CameraType.Scriptable
cam.CFrame = CameraFrame

CameraType API Reference