No
People's lived experience is very useful
Empirically, they're usually not nearly as useful as people think. People are on average unreliable observers of their own experiences.
Much better than individual anecdotes are collections of anecdotes that are searchable and somewhat categorized. A lot of old school drug forums provide this.
Much better still is systematically varying data and taking statistics to separate signal from noise.
As for a relationship to death, it's difficult to generalise over all people throughout history, but for example in medieval Europe where you had a seemingly quite vivid belief in the possibility of hell after life, that could result in some extreme anxiety of the most inescapable kind. Maybe that accounts for some of the more extreme behaviours of those times, who knows.
You know that how exactly? We really do not have even remotely enough data to be able to make such boldly absurd claims.
We need to give psychedelics a fair chance, and sure after we can discount them. The article suggests at scale there is potential