Singular Limiting Behavior in Nonlinear Stochastic Wave Equations