I played chess for only a few years, at a low level, and I encountered situations where underpromotion to a bishop or rook was necessary to win. It's possible it is more common at the just-above-beginner level than at the elite level, because a player in a losing position will play on longer and try to set up stalemate traps that would be pointless in higher-level games.