When I cancel a previously approved remote working request, does my manager need to approve it?

No. When you cancel a previously approved remote working request it is automatically cancelled but your manager (and any shared approvers) is sent an email and a notification.