Can I retrieve a deleted video from the deleted folder?

unfortunately, if you pressed "delete forever" on a video, then there is no way to retrieve it.

If the video was saved to your Apple device and you have a backup of that device, then you should eb able to access the video form the back up or from your photo iCloud.