Absolutely, yes! Not only real money or cash prizes, but you can also win free spins, reward points, and extra deposit credit when you win higher ranks in casino tournaments.
The important thing to remember, though, is that not every casino offers prize money in tournaments. But even the free spins or extra deposit you can use to win real money.
So yes, winning tournaments will ultimately make you actual money.