No, no, no, no, no. Government is entirely different.
Loyalty of each member of government is to the people and to the country, not to the chief executive. Example: Let's say a cabinet member learned that in fact Trump was planning something incredibly stupid and dangerous. It can be whatever you want, let's say bomb France. That cabinet member's duty is to tell the right people to prevent Trump from doing it, not to argue with Trump and then just give up and let it happen.
The DNI has a duty to tell Congress what is going on. WHAT IS ACTUALLY GOING ON. Not the spin Trump wants put on it. Even if the intel hurts Trump, it is nonetheless the duty of the DNI to tell Congress. Saving Trump some embarrassment absolutely pales in comparison to that duty. Its not even close.
All of you boiling this down to a simple question of institutional loyalty to Trump because he is President need to take a serious look at what you are saying. Put the shoe on the other foot and think through your reaction if the DNI did not tell Congress, including Republicans, if it found out that Obama was born in Kenya and was a member of al-Qaeda, because hey, Obama was President.