It depends on the tone your game has. Is it a more casual game? Then maybe a generic “Game Over” will get the message across. Is it a more adult-oriented violent title? Then a gory death animation would add to that.
Obviously this is not black and white, your game could be anywhere in between, so it’s hard for any user to tell without knowing more about your game.
Hope that helps :)