Europe’s ‘most iconic ancient tree’ will live on in legends only after dry and hot summers meant it failed to produce leaves