On detecting violation of local realism with photon-number resolving weak-field homodyne measurements