Yes, there is alcoholism depicted in one scene where a dead singer is brought out to woo the main character. There is also a joke made about cigarette addiction.
No pedophilia but there is a joke where two characters awkwardly stumble into a conversation about 'hot kids' and then have to clarify they are not into that.
The other comment is incorrect, the character chokes on food. They do fall down and hit their head however. Not sure which actually killed them but the film repeatedly references choking after this.
There are both depictions of those who died reverting back to being in a child form, and at least one who was a child when he died. There is no showing of these deaths on screen, just mention in dialogue.
There are many mentions of sex throughout the movie, such as a 'free use' and an 'everything goes' eternity, as well as slight mentions of BDSM and sex in a few lines. There is also a sex scene.
There are many mentions of people who are LGBT and have died, but it is very respectful. There is even an Eternity made for queer people who have died.