The script is ponderous, but thrilling songs bring the story of musical pioneer Sister Rosetta Tharpe to life