Ah good point. I'd forgotten about that!
I found this article where Terry Matalas says they wanted to keep the fate of Enterprise E a mystery so fans could have fun speculating about it:
Terry Matalas On Why Janeway And Harry Kim Weren’t In ‘Star Trek: Picard’ And The Fate Of The Enterprise-E
“We had ideas, but in the moment where they’re asking, ‘What about the Enterprise-E?’ it would not have been good for someone to be like, ‘Well, the Battle of duh, duh, duh.’ You are looking at the Enterprise-D! You couldn’t do it and you wouldn’t do it justice, whatever it is. You could say it is in storage or we are repainting it. You could, but I thought, but I thought it was way funnier if they all turned to Worf and he’s like, “It wasn’t my fault.” So everyone is going, “What the hell happened?” That’s way more fun. Somebody can tell that story some day about what happened with Worf and the Enterprise-E but it’s more fun to imagine yourself all the possibilities. Is it lost in an interdimensional rift and it’s still out there somewhere? Was it an accidental self destruct? Who knows? The question is almost better than the answer.”