Summary:
Only the Timesheet Audit trail report (also called Audit trail report) shows comments entered by an approver while rejecting a timesheet. The field that has to be enabled, to see the comments in the settings is Change Comments under the Column tab.

Note:
This field also show "resubmission comments" entered by user when re-submitting the timesheet.