The professor, who rapidly rose through the academic ranks after a difficult start to life, resigned from his post at the University of Cambridge on Wednesday