As of the current support page, only "public" calendars are allowed:
You can only add a calendar using a link if the other person's calendar is public.
(The support page is about adding "someone else's Google calendar" specifically, but it seems to apply for any iCalendar source as well.)
You can get around this by:
Asking the calendar'...