They had 1000 or so satellites when I first started testing, and there are now something like 1600 or so. Most of the time, I don't even notice when it switches satellites.
If you were doing some more real-time work or extremely latency-sensitive operations, then yes, you need to stick to a different type of connection. But it's really seamless now, compared to even a few months ago.
Most of the software I used either showed no sign of the dropout, or at worst would freeze a frame or show a loading indicator for a brief moment before getting back to normal.
Online multiplayer gaming and/or streaming are the main areas where I'd have to not recommend Starlink for now.