Do I have this right?
You missed a shift, meaning caused a mechanical over rev.
The car clacked and ran like poop.
Upon inspection, you have oil in a cylinder and evidence of valves striking the piston.
I think it is fair to assume your valves are bent, guides have been damaged, and maybe some debris has been released into the cylinders. I think starting it will just result in further damage but certainly will not result in a healthy engine.
Drop and rebuild x2