Remove `@on_demand_benchmark` from memory benchmarks

## 📰 Custom Issue


We turned these off in #something

Should be OK to bring these back once #5948 is merged, because `tracemalloc` appears to be more stable. We can always undo if not.