There's no way to reconcile the current TNG era relaunches with Picard at this point. I think David Mack's Tweet may have been tongue in cheek---or maybe at that time some thought something could be salvaged. But there's no amount of knots you could do to bring the relaunches as they stand in line with Picard. And it's not really a surprise. The little bits we got before the show even started strongly indicated the show was going in a vastly different direction then where the novels were headed.
I think we just have one more relaunch novel coming out, Voyager's "To Lose the Earth" (though that is admittedly a few years behind "Collateral Damage". Hopefully Beyer will tie some things up. I would have loved to have seen one more DS9 book to tie up some major loose ends as well. But sadly I think time is up. The only reason we're even getting another Voyager novel is it was already contracted previously. Otherwise I don't think we'd even get that.
I think from this point on the books will all center around the current running shows and the original series. I don't expect to see any more TNG, DS9, Voyager or Enterprise books at this point. Unfortunately, at least IMO, I think the franchise has moved on.
As much as I love seeing a new 24th century show (though as I noted on another thread I'm not sure I like where it's headed), I have to admit I regret seeing the continuing relaunches end. I guess I just kind of assumed they would continue indefinitely. It seemed we were just on a continuing voyages journey that would never end.