I'm very rarely a player, so perhaps it's more difficult for me to get into the player mindset.
To me, the randomness reminds me of when I was in middle school and my character got access to a Wish spell through a Deck of Many Things. I Wished my friend's character into a woodchuck. There were lulz.
Random charts seem good for that old-school mentality where you enjoy seeing terrible traps and awful spells destroy your friends' progress in the game - because "at least it's not your character."
As one of my players commented last session "It's not 1974 anymore." I don't need adversarial charts of terrible, random things to do to characters, like a game system that uses Grimtooth's Traps as its core resolution mechanic.
Put this way. I love classic arcade games. I can happily play Galaga for about 15 minutes to see if I can beat my personal record before I lose my ships, but I'm not going to lose myself in it for hours like I would Skyrim (or my wife does with Breath of the Wild or Baldur's Gate 3). DCC seems like one of those classic arcade games.