The queen is the most powerful chess piece so many beginners think that it's a good idea to bring it out early. After all they want their strongest piece to contribute actively to the game instead of staying back on its starting square.
But more often than not, brining out the queen too early is a bad idea.
The queen is the most powerful piece but because of this reason you shouldn't bring it out too early. Being the most valuable piece also makes the queen the most vulnerable piece. It has to move every time it is attacked by a pawn, knight, bishop or rook. Due to the high value of the queen, every exchange for another piece is unfavourable.
Your opponent always gains time when they attack your queen, so having an exposed queen means that your opponent will gain an advantage in development.
Example
The drawbacks of bringing out the queen too early are well illustrated in the following game, Greco-NN, 1620.
1.e4 e5 2.f4 exf4 3.Bc4 Qh4+
This move is still fine but later on Black will have to be precise since their queen is exposed.
4.Kf1 Bc5?!
This allows white to grab the centre with tempo.
5.d4 Bb6 6.Nf3
Attacking the exposed queen.
6...Qh6?!
6...Qd8
7.g3 Qh3+ 8.Kf2 fxg3+?
This was a mistake and now Black gets punished for moving out the queen too early.It may look sensible to weaken the position of White's king even further but the queen is too short on squares.
8...Nf6! 9.Bxf7+ Kf8 10.Bxf4 Nxe4+ 11.Kg1 Kxf7 12.Nc3 Rf8 13.Nxe4 Kg8 and Black is slightly better.
9.hxg3 Qg4
White to play and win.
10.Bxf7+!! Kf8
10...Kxf7 11.Ne5+ This also wins the black queen.
11.Rh4
Now the bishop controls g6 so the black queen has no squares left.
1-0
Notice how bringing out the queen initially wasn't a mistake but with the queen on h3, Black needed to be precise in order to stay in the game.
Why are there many games where it works?
As with all rules in chess, they depend a lot on the specific position.
Often times the queen is brought out early in order to achieve something specific. In the game above, the move 3...Qh4+ prevented White from castling. But as you have seen, keeping the queen exposed can backfire quickly.
Another common reason for bringing out the queen early is to regain a pawn or attack vulnerable points in the opponent's position.
But whenever you see an early queen move, you should question if it really achieves something and you also have to be careful that you queen won't get trapped. As you have seen, strong players have won games against opponent's that bring out their queen early since over 400 years.