(FWIW I perceived your comment as "natural curiousity" moreso than gawking, thanks to your respectful hedging.)
Furthermore, such questions can sometimes come across—or even be—blameful. For instance, asking 'What cancer did they die of?', 'Were they a smoker?', 'Were they obese?', or 'Did they work with chemicals?' might suggest judgment or responsibility, even if that’s not the intent. And as mentioned, sometimes it actually IS the intent (trying to find a way the person caused this on themselves), even if the person asking tries to cloak this, perhaps also to themselves. This can add unnecessary pain to those grieving.
I think not wanting to know unless the information is volunteered is also a natural human response.
I admit I wondered as well but I also know that most answers would be incomplete. So instead I watched a video of his. https://www.youtube.com/watch?v=UPkJGU7Itb0
I think what I wonder a little bit more about is why it's seen as inappropriate for people to just wonder what happened, even though I feel that's a natural human response, especially if they knew the person in some way (as long as that wondering doesn't move into boundary crossing).