The latest Museums Moving Forward report on museum sector satisfaction found a few bright spots amid persistent low pay, inequity and burnout