Oh my goodness, I do this all the time. I wrote a beast of an article on the use of AI in behavioral health. No one cares about that. I read the ten minute piece aloud to the dog and she left halfway through. She is always by my side and she left!
Then, I asked a second opinion and my husband gently told me to scrap the piece. I've left it in my drafts folder just in case I can use it for parts. Ha!
So, I feel your pain. If you let it sit and percolate for a week, maybe it will suddenly all come together. Or, throw it out into the universe and see what happens. It could be your next viral article.