Broken spark plug - ruined engine? 1.4TSI CZCA

Afternoon all, is this as bad as I think it is?

Bad noise, check engine light, error codes P0300, P0302, P0303. Changed ignition coils on cylinders 2 and 3 which didn't solve the problem so checked the spark plugs. Spark plug on cylinder 2 was missing the tip! It appears to have broken off while in use! The spark plugs were changed 2.5 years ago with Bosch ones. Picture of broken spark plug and video of bad noise attached.

Is my brothers diagnosis of "might need a new engine" an accurate one? I'm hoping I can fish the piece out with a long thin magnet, stick a new spark plug in and then everything will be good as new again!

Car is a Golf 1.4TSI mk7.5 with the CZCA engine.

Cheers