Season two is a wild fever dream that isn't anything like Star Trek. Someone wrote a different show, honestly not that bad of a show, and then just tossed in Star Trek characters. Like a bad Star Trek fanfic, but also weirdly good at times.
Never watched Picard, but that's how I felt about Foundation. It wasn't that it was a bad show, but it didn't feel anything like Foundation and I couldn't get into it.