It is indeed.
3GB should be addressable put of the 4 installed
If it works on a G5 , no reason it won't work on a C2D.
SATA is SATA.
TRIM support is questionable on an older OS though.
@LaatSahab
If you've got an old SATA SSD lying around , it'll make a big difference to the responsiveness...