The Art Newspaper's annual survey shows how the pandemic had a devastating impact on museums around the world—but there were some silver linings