What is the penalty to dying inside Elder Tale?
This is covered later in the LNs (which are being translated and are available here):


Adventurers lose EXP while NPCs die for real.
However, there is an additional penalty that is not obvious: when an adventurer dies they lose some of their memories.


Major spoiler:


   If the cathedral is destroyed, adventurers cannot respawn and die for real.