Having taken Aston Villa to the brink of Champions League football, O'Neill felt the club's ambitions faded