The former Newcastle United manager was awarded a CBE at Windsor Castle on Tuesday for his services to football and charity