The actor and singer discusses the origins of “The Rocky Horror Picture Show,” his relationship with David Bowie, and the joy of working with Miss Piggy.