Hello,
I encountered the issue in the headline. I was able to produce correct p-values using psych::corr.test. My first quess is that denominator is n which is taken from dimension of the matrix but not as number of pairs which were acceptable due to missing values.