After flying to base and hitting reset I continued the quest and the red door is no more. Please make sure you reset the quest or the door will be red. I checked.
This is for Agents that chose to destroy the codex.
By the way I could not continue the quest not because it was broke but because my friend was not logged in with me and he wants to see the ending as well.