Get rid of __del__

Also replaces log record with raising ResourceWaring.