Carrot Top's rep gave a candid update on the comedian's condition following his hospitalization for a reported suicide attempt