Picard season 3 was like a fanfiction of someone who liked the TOS movies and wanted to retcon things he didn’t like about the TNG movies. Some of the nostalgia makes no sense. The Enterprise E should have been in it.
They retcon perceived wrongs from the TNG movies but keep bad things from Picard season 1 and 2 intact. When they should have retconned those. The worst thing about Picard is not fixed. Everyone knows it but because there might be someone who hasn’t seen these i won’t spoil it.
Its basically the Nemesis sequel movie extended to a mini series. It might have been better as a slightly longer than 2 hour movie.