I don't think Salvia would be a suitable touchstone, because unrelated to any thoughts or visions of death, it tends to produce a confusing and fearful state of mind, and generally (because of either the effects or the duration of them) no death & rebirth experiences. One may instead experience existence as a sinister treadmill or a meaningless trap.
Regarding death, I think it's natural to fear it, and one can never eliminate that fear completely. Not just death, but also old age, debilitating diseases, fractured bones, suffocation, being born again, all these things are and will always be quite uncomfortable, no matter how enlightened one may be.