Docs: Update execution hint docs for Significant terms agg

copied over the relevant pieces from the terms agg

Closes #8532