Does the chainlink node need access to the keystore.json?

Sure, the node you run have its own EOA which store link and pay for gas fee when you perform reverse transaction.

It pulls the keystore from the db. If you remove the file, it will just be recreated.