As a long term creative cloud all apps subscriber working as a freelancer in the industry, I'm %100 sure After Effects has a memory leak issue still today..
Ae 2023, empty project, fresh vanilla installation, 1440P .h264 footage and just a single tricolor effect on top, footage playback speed is %30 (timelapse) and scrubbing around the timeline, changing one of the colors of tricolor effect and memory usage is %99 in less than a minute.
I have a 64GB Ram 20cores running at 4.3 no stability issues whatsoever.
This memory leak is using approximately 57GB's of ram..
This problem started happening with the version 2022 I believe..