I read to watch the Summer Game Fest 2023 stream for 30m, which I did. What I did not know, was that I had to watch the game awards in a very specific window of time despite the game awards stream lasting a full FOUR hours. Should probably be more clear it was for only for an arbitrary window of time within that entire 4 hour stream in the future. I'm usually very meticulous and I somehow missed that entirely.
After digging further... yep... neither the tweet
nor the link inside the tweet https://www.warframe.com/news/summer-game-fest-2023 mention the drop only being within a specific window of time.