The pompous know-it-all despised by classical philosophers became a stock comic character of 16th-century theatre – and finally a bore to be pitied