Elsewhere during the rare interview Macaulay revealed one role that he regretted skipping as he retired from acting in the mid-1990s