4 GB of RAM was acceptable when Win7 first came out, but, a little lacking these days, IMO....
Any Core 2 is at least 12-13 years old....
That being said, Core 2 Duos are still competent at basic office work, but, not sure about 'After Effects'...but, if it is modern software, it might still work, but, I rather doubt it would ever seem fast/responsive