After Effects has come in many versions for the Mac. Which version are you intending to use?
That camera doesn't record to a memory card, so you will have to capture the footage off of the tapes to get them into the computer. How you capture them will determine whether it will work with After Effects.
Most likely it will work just fine.
I'll be using the latest update from Creative Cloud. Would you happen to know what the process is to capture the footage of the HVR-V1P for AE CC?
Well, the simplest would be to use a modern camera that doesn't use tapes, but since that's not an option...
Capturing it in Premiere would probably be the simplest.