Apologies for the delayed weigh-in on this thread, but I was connectivity-challenged for most of January...
HJ and Fester pretty much hit it on the head - you're either part of the Ready Room or you're not. The quickest and easiest way to tell if you'll be a good fit as an intel officer in a Ready Room environment is to honestly answer this question:
Do you think farts are funny?
If "yes" and you tend to respond with counter-battery fire of your own, then you'll do fine. If you look around for the culprit, sneer, and say "Oh, grow up!", then you're in for a long tour. And I'm not kidding on this point.
As to which job is more "interesting": it really depends on your personality. Both are for detail-oriented mindsets. If you like to solve problems, then Supply may be for you - supply is a big constrained optimization problem. Intel is more about "knowing stuff", which sounds completely stupid but is really gets to the heart of the intel business: you are what you know. Of course, it helps that if the "stuff" you know is directly relevant to your assigned command's mission area - being knowledgeable about World of Warcraft doesn't count for much. (On the other hand, the ability to quote the entire screenplay from Monty Python and the Holy Grail would serve you quite well.) You can make yourself irrelevant pretty quickly if you can't demonstrate relevance, and the fact that you were pretty knowledgeable in your previous assignment means jack at your current assignment if it's not transferrable. If you are a quick study, you can go far. IMHO, one of the best attributes of a good intel officer is intellectual curiosity - if you always want to "find things out" or "know what's going on in the world", then you'll do well. If you are dense, overly serious, are uncomfortable speaking in front of others, don't think farts are funny, or (god help you) have some kind of physical deformity, you're in trouble...
As to the "Day in the Life" question, it's tough to generalize since a JO can fill jobs in so many different communities. In a squadron, you're carried along by the same tide that carries everyone else - whether you're underway, forward deployed, at home station, at exercises, etc. I've found that since a below average 3rd class Petty Officer can handle most formal and informal squadron AI jobs (e.g., Security Manager, Snack-O, etc.), I was able to use large parts of my day to get smart on my platform, or get things done that benefitted the squadron as a whole. Sometimes this meant sucking up the shitty little jobs that come around, sometimes it meant taking on the cruise project, or other such things. I was a good Admin planner, and generally found the good restaurants and interesting things to do wherever we went as a squadron.
Anyway, I'm starting to ramble from time-zone dislocation - good luck on your application!