There's a couple different standard paths an intel officer can start out in. You might go to a DCGS site and lead a team of analysts doing that mission. You can go to a flying squadron or an operations support squadron and provide intel support to flight operations (ie briefing threats, tactics, etc). You can go work for a three letter agency doing those sorts of things (but not like the movies, sorry). Once you've cut your teeth for a few years in a standard assignment, there are a multitude of unique, weird things that intel officers can go do. Some units have 14Ns who are qualified as aircrew. I've met 14Ns who've been to real jump school (no offense to AM-490 grads) as a part of their assignment. There are 14Ns who do assignments where they don't wear uniforms. The sky is the limit and it's possible to go deep and dark into the rabbit hole.
The most important thing to know about being an intel officer is you likely won't be an analyst, at least now how you expect. Plenty of intel officers do very important, tangible work. But your role is still that of most any other officer: to lead Airmen. Intel officers will have enlisted analysts who work for them. A 14N's job is to know the mission, yes, but most importantly to harness and direct the analytical brainpower of their subordinate Airmen/technical experts towards accomplishing the mission. Intel officers lead the intel mission.
I can't say enough good things about how fulfilling the intel mission is in the AF.