As an officer, you will be leading sailors. But as LET73 points out, you will still be doing intel. The sailors fill in a lot of the blanks or do pieces of work for you that make a bigger product. As an IS, you'll have more opportunities to specialize than as an officer, and depending on your long terms goals that might open some doors for you at highly specialized three letter agencies later. It just depends. Quality of life will be better as an officer for sure.
Many new intel-o's end up at a squadron doing security/ATFP work for a few years as their first tour before moving on to staff jobs/DC work.
Unfortunately, as revan says, most squadron intel Os end up stuck doing collateral duties all the time. A part of that is because of the attitude that....
Just like any other ENS job, you don't know shit and everyone else knows a lot more about everything than you do.
Which isn't always true, and is toxic to the intel community. Squadron intel Os are underutilized, which leads to a lack of good training, which leads to collateral duties. Further, the bad reputation scares off promising first/second tour officers, which hurts the squadrons. As you can see, it is a vicious cycle, but it is one that is getting attention among CAG AIs (wing intel Os for the unfamiliar) and is hopefully changing in the future. The training is getting better for all navy intel Os, as are the resources for squadron AIs to learn independently. There are some damn good squadron AIs out there that can help even patch wearers better understand the threat, whether it is about enemy IADS, AAMs, and even some stuff at the tactical level (this last bit I will concede is pretty rare). In short "they don't know shit" is a bad approach for both the spy and the squadron, as they won't actually get the most out of each other.
Of course, the easy thing to do if you don't want to end up being a security manager/geedunk O/EKMS manager/1324 other things for 2 or 3 years is to not pick a squadron, which is easy, but if you love aviation stuff, the best thing to do is pick it and do your best work so that you don't end up doing so many jobs and so that your successor doesn't have to either. Another trick that works (but not always) is to try and get in squadrons with more aircrew.