I think "fatalistic" is a better word than "contradictory". I otherwise agree.
There are a lot of misconceptions about the Big Bang. The Universe is a metric space. The "metric" part here is deliberate, specific and technical. It really means that given two points the metric can tell us what we call the "distance" between them. Abstract maths deals with spaces that do and don't have metrics.
The best explanation I've heard of the Big Bang is not that the Universe originated from a single point but rather the metric between all points in the Universe at the time of the Big Bang was 0.
There's an open question about whether the Universe is finite or infinite. I mean the actual Universe not the observable Universe. This is almost a metaphysical question since we'll probably never know.
We don't really know how gravity and space acts in such extreme environments but with black holes (that we also don't understand at the quantum level) we have plenty of examples of admittedly less extreme but still exxtreme corollaries. It is kind of mind-bending though. One description I read says that time acts like space and space acts like time within the event horizon. As in, you can see light entering the black holes behind you but that's the past and we can view the past all around us (eg distant galaxies are us viewing the past). Towards the singularity is the "future" and we can no more see that than we can see any future.
We, as sentient beings, have a difficult time comprehending things beyond our existence. What I mean is that before we were born, we didn't exist. After we die, we don't exist. We can't really comprehend that intuitively because our perception of the world is predicated on our cognizance. The past is easier. Stuff happened before we were born. But now we do exist. So at some point in the future we won't exist. How can you comprehend your own lack of existence?
I feel in some ways similar about the Universe. Our observations are predicated on concepts like "time" and "space" that at some point didn't exist. How do you reason about the lack of existence of space let alone time when everything we know is predicated on that?
Still, I too feel like the author is too pessimistic about how much more we can learn here. Assuming we aren't extinguished in the next few centuries (which is actually more difficult than it sounds at this point) we are going to be here for an inconceivably long time. Given our understanding of the Universe, that's likely to be >10^100 years. That's a long time to figure stuff out.