Add pprof to the components of Substrate

[bowei]

(This item came from the Substrate summit in 2026-07-13)

We should enable pprof profiling (cpu + memory) for all of the substrate components.

[zoez7]

Troy Chiu (@troychiu) is interested in working on this

[troychiu]

Thank you Zoe Zhao (@zoez7). I can help with this one.