John is NOT dumb. He’s NEVER been dumb. He is incredibly smart. A genius chose him as a companion.
You can’t compare their intelligence because Sherlock is on another level. No one, with the exception of his brother, can match him. That doesn’t make John dumb.