Look into enabling edm::ESTransientHandle memory optimization again

[makortel]

After all EDModules have been migrated to EventSetup consumes (#31061), framework knows exactly which ESProducts are consumed at which stages of the application. With this information we could look into enabling the memory optimization with edm::ESTransientHandle again.
https://twiki.cern.ch/twiki/bin/view/CMSPublic/SWGuideHowToGetDataFromES#Optimizing_memory_usage

[cmsbuild]

A new Issue was created by @makortel Matti Kortelainen.

@Dr15Jones, @dpiparo, @silviodonato, @smuzaffar, @makortel, @qliphy can you please review it and eventually sign/assign? Thanks.

cms-bot commands are listed here

[makortel]

assign core

[cmsbuild]

New categories assigned: core

@Dr15Jones,@smuzaffar,@makortel you have been requested to review this Pull request/Issue and eventually sign? Thanks

[makortel]

All EDModules run in IBs have been migrated, and esConsumes is now enforced at run time (#35588). Therefore this optimization could be thought more seriously now.