It’s not that they need to be consistent, but that the subs most related to the wannabe major are strong.
A stem hopeful might get a high Composite but, eg, low subs in math and/or sci. That’s not helpful.
And depending on the competitiveness for an admit, how low the lows are can be an issue.