Former WWE women’s champion Paige was at “rock bottom” and was not sure she wanted to be alive anymore