It really depends on what kind of products you're talking about and how they're being stored. For example, if you're talking about physical products that need to be shipped, then you're going to need to factor in inventory management. If you're talking about digital products, then you'll need to consider file storage. If you're talking about online courses, then you'll need to consider course management, etc.
Generally speaking, WooCommerce is a pretty robust eCommerce platform and can handle a lot of different products. However, there is no such thing as a "one size fits all" answer when it comes to how many products a WooCommerce site can support. It really depends on your specific needs and requirements.