Asymptotics and lower bounds for complex and real counts of singular surfaces in $\mathbb{P}^3$