I suspect a lot of info is restricted to a need to know basis even for the president no matter who that president is. There is so much secret info that no single person could be expected to know or keep track of it. Also there is no more secure system than for the president to not have info that could inadvertently slip.
Generally speaking I agree. Compartmentalization is a good thing for security. My kid's last gig in the AF was flying Hagel and they had no clue where they were going half the time much less anything of natsec substance...and her clearances back then were pretty high.
On the other hand, I would expect the CIA, ESPECIALLY the CIA run and staffed by Barry and ValJar for 2 terms in this instance to ensure Trump didn't get info he SHOULD have in order to intentionally cause a national incident/war/terror attack/insert disaster here because they put power over country as a matter of course. Their record for integrity isn't exactly stellar.