In "percent vaxxed among positive tests" you're only looking at those who got tested and were positive at a snapshot in time. At the very least, you also need to include all the people who tested negative. You complain that the size of the vaxxed and unvaxxed populations are vastly different but then use numbers where you look at just positive tests, ignoring counts or negative counts. That gives you numbers with even more potential sources for skew!

The table on page 40 is consistent with US data, where case rates at the population. It says to read in conjunction with pages 32 to 34, which basically says "stats won't be as accurate as formal assessment of vaccine effectiveness, please see the formal data." The formal data suggests effectiveness against transmission. The raw cases-per-100k numbers agree. Yet you latch onto a different number - another one that the report says isn't authoritative for those purposes either - to claim the data shows ineffectiveness! That seems backward.