This happened to me a long time ago. Apparently, changing the date on the note that’s out of order fixes the problem, or at least that fixed my problem back then. So, you could change the date on that note to July 31, and then change it back to Aug 2-8.
Apparently, this is a very rare bug that the Agenda folks haven’t been able to figure out. I did many of the same things you did, thinking mine had to be pinned, etc. Changing the date was the thing that finally worked. Hope it works for you!