memmapped arrays only closed at garbage collection when asdf.open given an open file

This resulted in failure of the astropy CI as astropy.Table.open opens the file before handing it to asdf to read the table.

This regression was introduced in PR https://github.com/asdf-format/asdf/pull/1230