Try explaining to people why it’s hard to count rows across distributed databases.
The solution is to loop through paginated products and aggregate the count. Either you do the processing or expect Shopify to do it. Yes it would be nice, but is it really needed? Honestly there are more important things Shopify should spend time on.
If you think you need an accurate total count from a single query, I’d start by looking at what is it you’re trying to do.