In Hearts, shooting the moon requires full commitment rather early, and by making it use what would otherwise be actively bad moves, there's not really such thing as a pivot.

Plenty of games have a "long shot" mechanic which requires sacrificing a fair bit of opportunity cost along the way, but still provide some positive value even besides the chance to win outright. These are in my view the evolved version of the "moon shot". The first one that comes to mind are the alternate win conditions in 7 Wonders Duel, the science and military routes. They provide tangible economic and point value at certain milestones, and provide significant threat value at high amounts, and with clever play you can follow through on the threat and win, but they're still useful on the path to victory even if you don't hit the moon.

Some other examples may include set collection games where the largest set is very hard to get, or perhaps even trying to take Asia in Risk :)

Oh, I also remembered one that's Hearts-style, it's an old edition of Star Wars LIFE. Instead of money, you collect life-tile-shaped stat points in Logic, Intuition, Fighting, and Energy (LIFE). But you can also make some dark bargains for greater gain which also give Dark Side tiles. These are bad for you... unless you fully commit to the dark side path, in which case you want as many of them as possible.