Allowed memory size exhausted when using revisions caching

Problem/Motivation

In 📌 ContentEntityStorageBase::loadRevision() should use the static and the persistent entity cache like ContentEntityStorageBase::load() Needs work there is work being done to add caching for node revisions. When using the patch for the node revision cache, nodes with a lot of revisions can cause out-of-memory errors while running the queue.
I guess this makes sense, some NodeRevisionDelete plugins load all revisions and when these are cached this can add up to a huge amount.

Steps to reproduce

1. Implement the latest patch in 📌 ContentEntityStorageBase::loadRevision() should use the static and the persistent entity cache like ContentEntityStorageBase::load() Needs work
2. Enable the node revision delete module
3. Create a node with a loth of revisions
4. Try to run the queue and observe out-of-memory errors

Proposed resolution

Reset the revision cache in plugins that load the revisions.

Remaining tasks

1. Test the patch
2. Review
3. Wait for 📌 ContentEntityStorageBase::loadRevision() should use the static and the persistent entity cache like ContentEntityStorageBase::load() Needs work to be committed
4. Commit

User interface changes

None

API changes

None

Data model changes

None