Very detailed and straight to the point article as always. A couple of months ago I wrote a similar although very small post as a response to a comment I made elsewhere:
https://blog.devops.dev/event-sourcing-is-not-event-streaming-960963c5d6d5
I would argue though that it is not impossible to implement a limited niche event sourcing solution by using single partition topics in combination with kafka transactions and compacted topics (eg. you would always snapshot) - but this is far from ideal and would be of very little use except in very very small niche cases.
All in all, don't use Kafka for event sourcing "especially" if you are doing it for the first time.