Tone
I think you're relying on the exploration logs to carry the article. I think that makes sense, but that's also where a lot of the article falls flat.
Let's call a spade a spade here: Once you get past the Apollo gimmick and really dive deep into the log, this is Alien. Or maybe Alien with a little bit of The Thing thrown in.
I don't think there's anything wrong with that, but I think it's important to consider what makes those kinds of stories work. They focus on a group of people in a remote location who are isolated and underprepared, trapped with a monster they're ill-equipped to fight and don't understand. Then the narrative slowly cranks up the tension as mistrust and paranoia divide the characters at the time when they most need to stick together, raising the stakes as the chances for survival drop.
In your log, as it's written, the characters are well equipped and well informed, and approach everything in a confident, matter-of-fact sort of way. There's peril, but very little horror. And I'm not 100% sure survival horror is what you were going for, but if it's not, it's not clear to me what the intent was.
More broadly, the thing that makes the exploration log drag the most is that it focuses on characters discovering information that the reader already knows. Most of the discoveries are of information that is already included in the description, so instead of feeling like an exploration, it just feels repetitive.
If you want to lean into the survival horror element, you could use this to create dramatic irony: instead of having the characters instantly recognize and identify everything, you could have them remain oblivious to hazards that the reader is aware of. This way you can increase the sense of danger and vulnerability.
Concept and Theme
I don't know if thematically or conceptually the different elements of this hold together.
I love the trope of ancient people worshiping alien beings as gods, and the idea of dead alien gods drifting through space really sings for me. At the same time, I think those concepts usually work because they deal with such vast, foreboding subject matter. Apollo, on the other hand, seems like a mismatched fit. Of all of the gods of all the world's religions that are well known today, Greek gods are the most human-like. I feel like as a result, the image of someone in the modern day sincerely revering a dead alien as though they were Apollo reads as silly, even if it's a delusion.
I also think the connection to the Church of the Second Hytoth feels a bit shoehorned in without adding much. This might be a personal preference, but I feel like tying in to Foundation universe lore works when it's either a very brief illusion, or something that meaningfully builds on the lore. I think this is kind of a one-foot-in, one-foot-out approach, which just kind of muddies the narrative with references that don't pay off.
Suggestions
I have lots of ideas as to how you could iterate on this, but I don't want to backseat pilot this article, so I stead I'll just toss out two suggestions:
If you want the delusion to be scary, I think it would be a lot easier to manage if it were an aura that led people to believe the alien was whatever deity the subject worships, or a figure of supreme authority, rather than specifically Apollo. You could keep that the ancient Greeks saw it as Apollo, but maybe the people who are exploring believe it instead to be something modern people still believe in.
If you want to pull this all together, it might be best to lean into what really stands up, and build the rest of the article around it. I think the best thing you have going for it right now is the setpiece of the exploration log. It needs work, but the concept of scientists exploring a mysterious ship that turns out to be the tomb of a dead ancient alien god and would-be conqueror of Earth who still psychically compels devotion from beyond the grave is just really damn cool. It reads like Call of Cthulhu in space.