Ms. Houston reigned as pop music’s queen until her majestic voice and regal image were ravaged by drug use, erratic behavior and a tumultuous marriage.