Beset by challenges during the pandemic, the half-century-old institution is seeing new life after expanding its focus and seeking out younger visitors with a massive renovation