Yes for art-interested older children if you choose two sections, not the whole museum. The Romanesque fresco rooms and terrace give the visit clear anchors and room to reset.
The Romanesque galleries are the revelation: medieval frescoes removed from Pyrenean churches are installed in curved apses, so their original architecture remains legible. Gothic panels, modern Catalan painting and decorative arts follow, but trying to cover every floor weakens the visit. Choose two collections, then step onto the terrace for the long view down Avinguda de la Reina Maria Cristina.