Still people try martingale constantly. I am watching primedice and dicebitco.in and people use the bots (or manually) and grind away martingale for 10000s of bets. I guess they like the fact that they constantly win money until the big bang.
If you deposit 1 BTC and martingale from 1 satoshi, doubling on loss, you will probably never reach a long enough losing streak to bust. It takes around 100 million bets on average (very roughly).
Still, if everyone did the same, an unlucky few would bust, and that would pay for all the small gains made by everyone else.
So even when a strategy is overwhelmingly likely to result in a gain for individual players, it's still a net positive for the house too.
Even if martingale fails in theory with an infinite number of rolls*, in practice you can only make a limited number of rolls (even if you roll through all your life) and the number of players is limited at that. So the chances of losing deposit may still be lower then the chances of winning for
every player in particular and the
whole group in general (provided that they don't exceed their individual limits of total rolls determined by balance and the number of players). In this case the house will have a net loss even if some of the players lose in the end...
*in fact, this is the only case about which you can say anything specific without taking into account other factors (like total number of rolls and players)