I do not consider the part above labeled as 'historical present tense' to be actually historical present tense. To me, that is simple present tense, which I also think never works well in fiction.
The first problem there is 'a lady stands' which is truly simple present tense. That might work for 3rd-p, but in 1st-p the narrator is the viewpoint character, an observer, and 'a lady is standing' more precisely reflects an observation. 'A lady stands' is ambiguous, because not only could that be an observation, it could also be an omni-delivered fact not related to any observation, which is common in 3rd-p, yet not in 1st-p that is well-written. Also, it breaks the parallelism with 'dripping' and 'holding'.
The point of HPT is not to use present tense verbs, it is to place the reader in the same temporal position as the narrator/observer by using both present and past tense verbs depending on the event being described. 'Knocks', 'puts', and 'stares' are simple present tense verbs here. In HPT, these are typically replaced with past tense verbs: 'She knocked on the window'. This is also not simple past tense, this is a reflection of the immediate past relative to the temporal position of the observer (and reader), which is directly in the action in the scene rather than 'later', as it would be in simple past tense.
The knock was an incidental event. it occurred, and is over, from the point of view of the temporal position of the narrator. For the sake of argument, let's assume that instead, the lady kept knocking repeatedly on the window. In that case, it is not an incidental event, it's an ongoing condition relative to the narrator, and so would take a present tense verb, such as "She is knocking". The point is, the temporal position of the narrator and reader remain fixed within the scene, regardless of whether the verbs used are past tense (for incidental events) or present tense (for ongoing conditions). 'Dripping with sweat' and 'holding a baby' are also ongoing conditions relative to the observer, so those take present tense as well.
In other words, nothing that is an event that begins and ends and is reported to the reader by the narrator should take a simple present tense verb, because for any incidental event to be observed, it must have already happened, placing it in the observer's immediate past, therefore taking a past tense verb, relative to the temporal position of the reader and narrator.
The event is in the immediate past, but the temporal position of the observer/narrator and the reader are still in the moment just after this has occurred, which is known as the historical present.
This is also different from simple present tense, because simple present tense locks everything rigidly into the present. That doesn't really work, because to navigate the world, we constantly regard what has just happened, the immediate past, as well as predict the immediate future. We exist in the present, of course, but we also are cognizant of recent events and of what we think might happen next. So simple present tense is not natural to the real world as we navigate it.
But this is tricky to pull off. The other commenter is correct that 'I can't get this out of my head' somewhat moves the temporal pointer to a different point in time, pushing what was HPT into the past, and thereby undermining the goal of keeping the temporal position oriented close to the actual events as they happen.
The D-tag 'I challenge my uncle' is also simple past tense and not HPT, because it follows a line of dialog, and the key word there is 'follows'. In other words, the question the narrator asked their uncle has already been asked, so it is an event that is now in the immediate past, and takes a past tense verb: 'challenged', in order to preserve the temporal position and be considered HPT.
Unfortunately, not much works here.
The last paragraph, in past tense, can legitimately follow the previous ones (assuming they adhered to HPT and not simple present tense), but it is a definite shift in the temporal position for both the narrator and reader, so it will be jarring without a soft scene break, such as having a second carriage return is placed before it.