As far as service-selecting Intel....
Bottom line with all service selection is that you have to be "happy" with any of them. If Intel is something your DS/DD is interested in and that is their desire, then they should seek it, but with the understanding they might be asked/told to do something else (and obviously, would have to "live with it"). As NavyHoops mentioned, there are limited opportunities to lateral transfer later on (again, no guarantees).
Intel in the Navy is organized into the Information Dominance Corps (IDC) which consists of telecommunication/network, meteorology/oceanography, information warfare, and intel communities. As others stated in the linked thread....Intel supports specific Naval Operations...especially in the maritime environment and there is A LOT! Intel also provides support for all other communities...to include aviation, cyber, etc. Furthermore, as you become more senior, not only is there the opportunity for senior intelligence jobs and/or commands, but also the opportunity to command other IDC commands. For example, the Commanding Officer of one of the communications station is currently an Intel officer. The whole idea of the IDC is for each community to understand the advantage that information plays within their own area, but also as a whole (from the equipment that enables it to the intel or affects it produces).
-----
For clarification, the Navy has really two main categories of officers: (1) line and (2) staff corps. Line officers are further divided into Unrestricted Line (URL) or Restricted Line (RL). URL officers (i.e. SWOs, submariners, pilots, NFOs, etc.) are eligible to command combat units (i.e. ships, aviation squadrons, subs, special operations units). RL officers (i.e. non-civil engineering, maintenance, METOC/Oceanography, IP, IW, Intel, etc.) are not eligible to command combat units, but can command within their specialty areas. URL and RL wear their rank on both collars and have stars on top of their rank on shoulder boards and dress blues. Staff corps, includes those in healthcare, law, civil engineering and religion (i.e. Medical Corps, JAGs, CEC, and Chaplains) and augment the line commands (i.e. can be assigned to ships, subs, squadrons, etc.); they wear a symbol representing their staff community on their left collar (in place of rank) and on their shoulder board and dress blues.