That's the risk of rolling the dice when having that Blessing! You can say similar things about that blessing in Arm Wrestling, sneaking the Checkpoint and many many more roll quests! That blessing is actually why the game recommends Colbjorn as your Companion!

Right, Fickle Fate is risky, but Berta's Betting House is unique because the goal of round two is to roll less than the dice target.

For anyone not familiar:

Round 1 has no target. Whatever you roll in round 1 will be the dice target you're trying to beat in round 3 to win the wager.

Round 2 is a repeat of round 1. If you roll something higher than in round 1, it becomes the new target you'll need to beat in round 3. If not, the target for round 3 stays the same. Therefore, your goal in round 2 is to roll lower than in round 1.

Round 3 you just want to roll higher than the target you set in round 1 or round 2 so that you win the wager.

The problem is, if you roll under the target in round 2 (which is what you want), the game considers this failing a dice gambit, plays the failure sound, and triggers any gambit failure related events.

Berta's has always worked this way, it just never mattered very much because there weren't a lot of situations where it had much effect. But with Fickle Fate, it becomes a potentially run-ending complication.

It's not quite damned if you do and damned if you don't. If you roll the same thing in rounds 1 and 2, it'll neither trigger Fickle Fate nor make round 3 harder.

That's true, but I don't think it addresses the core of the issue, which is that this is a scenario where the player succeeding at their objective triggers an effect ostensibly meant to punish failing at their objective.

I imagine most players have the good sense not to play dice at Berta's anyway, since the nature of the challenge nullifies most of the dice gambit gear benefits, making it into a genuine gamble.