What does the author realize after his night in the redroom?

The author realizes that his fear of the red room was unfounded, as there was nothing supernatural there causing fear; rather, it was his own mind and the darkness that led to his terror. He learns to confront his fears and question his beliefs about the supernatural.