Picard wasn't a dikk as much as he was standoffish and cold. He began as a guy who wanted to keep a certain amount of distance bet6ween himself and his crew personally and eventually became the patriarchal figure of the entire Enterprise bridge crew.
But he remains distant from the crew throughout the entire series. He doesn't have a single relationship. There's the girl he used to know who runs off with Q.
There's one episode with that piano playing lieutenant. But she dies at the end of the one episode she's in.
Then Beverly crusher. They almost hook up but keep their distance out of respect for her dead husband.
Also they float the idea that maybe him and guinan hooked up, but it never comes close to materializing.
Then Wesley crusher disappears into time and space and picard never mentions it once after.
Yea the bridge crew perhaps as a team were closer at the end, but I don't buy picard being different at all. He handles himself the same. He's diplomatic and cordial, but politely keeps his personal distance because he believes a captain should..
Show me ONE specific example of him taking his professional relationship to a higher level I dare u.