Is there a big different in 35M job opportunities/experiences if you go airborne?

You will probably go to the 82nd where you will be part of an MI company, and yes the only difference is you will jump out of planes.
Later on you will almost certainly end up in a Special Operations unit because you are airborne and MI guys are notoriously risk averse D&D players. Depending on how they are organizing the MI detachment at that particular unit, you could be on an intelligence collection team or an analyst team. They aren't called that, but by the time you end up at a group they will have created a new acronym and reorganized the teams into something else. The only real guarantee is that you will do more than just your job.
Being airborne will open up many different organizations for you to work at where you are using your skills for real world intelligence. Most of them you haven't heard of, but you will once you are in SOF.

Every duty position in the entire Army is coded with an MOS, to include identifiers. Some of them REQUIRE airborne qualification. Other positions may require Air Assault qualification, or Ranger, or Pathfinder, or... well, pick a school that grants an identifier, and there is a job somewhere that specifically requires it. But Airborne is the most common REQUIRED identifier. Many duty positions will "prefer" a specific identifier - like most of the positions at Fort Campbell prefer Air Assault, but don't actually require it (but a few do require). This is for all MOSs, 35M included. Those positions, that identifier gives you a much better chance of "landing the job."
I say all that to say this. Basically what that airborne qualification does is open up more opportunities for different duty positions in different places - some good, some bad (which all depends on what you are looking for.) The job itself doesn't really change based on the airborne identifier, however some of the duty positions available with that identifier may have a different mission focus. But the different mission focus is a result of the duty position and unit mission, not a result of the airborne identifier. It's not like you are going to be conducting interrogations while "floating" through the air.
And having that airborne (or any other) identifier doesn't prevent you from filling a slot which is not coded for that identifier. Those slots are coded as "identifier immaterial" (my words, not official HRC language) meaning it doesn't matter whether you have the identifier or not.