To understand what's going on, try this simple demo of how the image circle changes in size at macro distances and reduces in brightness - effectively raising the f/number for exposure. It's an inverse square law effect and very familiar to large format film photographers, using those huge cameras with big bellows for focusing and a black cloth over your head - they're still used!
Find a plain wall opposite a window. Hold a bare lens with the aperture wide open (easy with Canons, tricky with Nikons

) a couple of inches from the wall and you'll see a circle of light with an image of the window - move the lens back and forth so the window is sharp and note the size of the image circle on the wall. Now hold your other hand in front of the lens, say a couple of feet in front and move the lens forward very slightly so the hand is sharp, and note that the size of the image circle hardly changes. Now hold your hand much closer to the front of the lens and you'll need to move the lens quite a bit further forward to get it sharp, and at the same time the image circle will become noticeably larger.
What's happening in terms of exposure is that as the image circle becomes larger, so the light is spread over a wider area and it becomes diluted and less bright. The physical lens aperture has not changed, but the effective f/number goes up.