Governor hails “remarkable turnaround” as Cardiff school removed from special measures