insights: add aggregation pings documentation

Created by: leonore

part of #41237 (we need to add proactive mode pings too)

Test plan

Checked docsite locally and sg lint docs