Running cardinality for more than 10000 buckets

Correct. The composite agg offers that guarantee too but can't sort by child agg (eg URLs sorted by number of unique visitors). The terms agg can sort by child agg but the order guarantees are only for the URLs that fall into the same partition.