It's more common than you think in queen and pawn endgames. It might even end in a dear with two queens in one side: It wasn't on the board because there were other fighting alternatives, but it was pretty close to happening just last week in the Grand Chess Tour finals, where Caruana saw that a second queen wouldn't stop MVL from getting a perpetual.

I'd not say it happens in every tournament, but many active tournament players will see it every year or two. It just happens that at the higher levels, chances are the set came with two queens, as upside down rooks are not great indicators for DGT boards.

The stubborn player situation will happen in real tournaments too, just not those full of GMs. It will happen in your typical rated weekly tournament in the St Louis chess club, where your top tables might not be IMs, or in scholastic tournaments.