The CCTV footage shows staff either asleep or absent from the ward as the alarms sounded and red warning lights flashed in the wee hours of August 24