Can single photon excitation of two spatially separated modes lead to a violation of Bell inequality via weak-field homodyne measurements?