Based on the title alone:
You can set the camera type to fixed or scripted, that freezes the players camera. You might want to make the camera is face something, this can be done with CFrames. If you want the transition to be smooth, you can use TweenService. Here is a page by Roblox on camera manipulation: Camera Manipulation
Based on the info in the post:
- You can use a particle effect parented to the HumanoidRootPart and set the enabled to true in a script when you want the player to “explode”.
- For making the player invisible, check this out: How to make player invisible? - #3 by hestolemyrice
Based on the video:
The only difference I see is that the camera shakes and fades with a white UI frame. The UI thing can be done by tweening the transparency of a white frame in and out.