Ben Chayeel Hamada scored the decisive goal in the 32nd minute to hand Comoros all three points and strengthen their qualification hopes.
The result leaves Congo bottom of Group G with just two points from four matches, while Comoros have moved to seven points. Namibia are third on three points, with Cameroon already securing qualification for the tournament after collecting 10 points.
Le Roy believes he has not fulfilled the task given to him and he is taking responsibility for the national team's struggles.
"I have failed in the task entrusted to me. I am going to submit my resignation," the 78-year-old coach told the media.
He acknowledged that Congo's chances of reaching the 2027 AFCON finals remain slim, despite qualification still being mathematically possible.
"Although qualification is still mathematically possible, it would take a miracle. We would need to win our remaining two matches and hope that Comoros lose both of theirs.
"It is still possible, but the best solution is to put things back on the right track," he added.
Congo's disappointing campaign has seen them lose 1-0 to Namibia, draw 1-1 with Cameroon and play out a goalless stalemate against Comoros before suffering another defeat to the island nation.
Le Roy returned to the Congo national team in June 2026, eleven years after his first spell in charge, with the ambition of rebuilding the side and securing qualification for the continental showpiece.