I flew in there today and find it a really nice airport. The location is really neat to fly along the shore and check out Patrick AFB and NASA.
In regard to the air carriers, I think mainline Delta flies MD
-88's in there as well from Atlanta. Including traffic, it's about a 30 minute to an hour drive to the Orlando area, so it isn't that bad