Statistics of $L^2$-algebraic decay rate for transient birth-death processes