“It was an absolute matter of addiction, withdrawal in the big leagues,” Presley shared in From Here to the Great Unknown, the book completed by her daughter Riley Keough after her 2023 death