Sharks have been seen off various beaches in Cape Cod, but none were scarier than the one who jumped out of the water and was caught on film