The way I read it is miles o’brien is supposed to be the blue collar everyman character that draws in people who don’t usually like star trek but they just miss the mark on that often and they make it doubly uncomfortable by also making miles o’brien a very flawed, pretty close minded person which causes cognitive dissonance like you said because all the other characters love him.