Although it's not open source, Linux-based creatives shouldn't overlook DaVinci Fusion. https://www.blackmagicdesign.com/products/davinciresolve/fus...
I mentioned it, because over the years my number one alternative to AfterEffects became Blender.
https://www.blackmagicdesign.com/products/fusion/compare
A dedicated compositor would likely want to lean towards paying for Fusion Studio rather than DaVinci Resolve Studio (both cost $295 USD). The standalone application provides greater flexibility in terms of working on multiple shots at a time (multiple scenes open) and being able to focus on the specific task at hand. If the work originates in Resolve, VFX Connect can be used to launch the clip in Fusion Studio.
https://documents.blackmagicdesign.com/SupportNotes/DaVinci_...