You know, all of it really depends on what sorts of consequences for catastrophic failure (such as character death or a TPK) the campaign has as options.
For example, I typically run about three types of games.
1) Theme adventure. 8-15 sessions around a theme, representing a short period of time during which the characters probably gain 1 level.
2) Mini-campaign. Something like Lost Mine of Phandelver.
3) Full Campaign. This is the one we've played for 6 years and the characters are level 5. Planning to go level 20 and beyond.
Just sticking to D&D for the moment, we can assume as a baseline that various forms of resurrection magic are available unless you are too low level to have reasonable access, but that there are some rare situations that can't be fixed with that kind of magic.
In a Theme adventure, I'd typically assume all failure options are on the table, so you might die with no way back, but if it's set at a higher level you can probably get raised. If the latter is the case I don't need to know much, because consequences for really messing up are fixable (and quite possibly funny). If death means you make a new character...well, I'd want to feel like there were usually some indication that you are about to choose death accidentally, but I would still likely laugh about it even if there weren't. It's a short game, and your character is essentially retiring after it anyway.
In a Mini-campaign, I'd ideally want to know what the options are up front, rather than making assumptions. Assuming the same as for the Theme adventure above, I would definitely want to know enough to estimate potential risk level of choices in broad terms, unless we had the resources to easily raise the dead, in which case it would be fine to occasionally stumble into something you had no idea was deadly. If on the other hand death was always going to mean making a new character, I'd want that knowledge to be a bit less broad.
In a Full Campaign, we definitely need to know what the options are. Under your standard assumptions, I would want finding out the approximate threat to be accessibly doable up until the point you have easy access to resurrection magic. And since it wouldn't make much sense to play that long with it working that way and then it suddenly doesn't, it should continue. If the game wasn't going to allow for resurrection at all, although I want to say I'd want more info, I just don't think more info beyond that point would mean more fun. So I guess that's just a situation where I'd have to try not to get attached to a character in the first place.
Now, this is where I get to the possibilty of different options than just the three I mentioned (no resurrection, resurrection at least eventually possible, or easy access). I really think an option where it is part of Session Zero that you will never lose your character unless you want to to be a great alternative for a Full Campaign (or those tiny little 1 year things these kids today think are full campaigns because of WotC marketing strategies). Some game systems have this built in by default, but D&D hasn't played with that concept much (other than the Planescape Torment video game where it was a core plot element, and the adventure in the 5e Planescape product, where they made an inferior riff on that). The dea I would propose is that it's a default D&D world so resurrection is usually possible (but not always cheap or easy), and you play the game letting the chips fall where they may. But there is a guarantee that regardless of what happens to your character, nothing will permanently take away your ability to play them. So maybe you die in a way that specifies you need a wish to come back, or someone has to go find your soul, or you need divine intervention. The DM doesn't have to just drop you the quest to get that at the start of the next session, but starting on a path that will eventually lead there has to be accessible. (Presumably you play an NPC friend or such while this is going on.) Honestly, for me this is a part of the essence of D&D. The PCs can have the possibilty of overcoming anything eventually. If that's the assumption, then I'm in the situation where I'd usually want to be able to gather threat info in broad terms, but occasionally it's probably fine to be completely surprised with no way to have prevented something from happening. Because it's fixable. (And hopefully funny. Do not underestimate the power of comical demise.)