It makes parts of the CIA look incompetent to the public. This is rare.

It’s reasonable to assume they knew it from the start he was getting money illicitly from the Navy and they might have enabled it. This was part of the leverage they had on him, to be used if he ever became a liability.