The phrase comes from Ralph Waldo Emerson’s essay Self-Reliance: “A foolish consistency is the hobgoblin of little minds.” It means:
Irrational fears and rigid conformities that plague narrow, unreflective intellects.
Emerson argues that blind adherence to consistency (social, intellectual) is a refuge for the insecure. Great minds embrace contradiction and growth; small minds cling to false safety.