Characterizing the formation of singularities in a superlinear indefinite problem related to the mean curvature operator