After playing around with bursting for a while, I realize that I can download the bursting report by clicking on Report Job History --> click on the bursting job name that ran successfully --> click on the output name under the tag Output & Delivery.

Then the output will be downloaded and I can check it out. And the path needs to start with C:/ for it to actually run and send the report.