Science museums are FUN because the experience is the purpose: teach people scientific principles or exhibit the (progressive) history of science.

Art museums have different purposes: historical theses, expression, cultural development, discussion, drinking, or money laundering.

It makes some sense: science museums are educational focused, art museums are about very boring things that adults enjoy but kids might not.