No, you're right. Most that I interact with won't be SEC fans, except for the increased paycheck over the Big12. I think there's a ton of respect for Tennessee as a program and school. Still a lot of love for Josh and his time here. Total hatred for anything the fake UT (texsucks) does, up to and including cheering for them to lose to Washington. Most of the fans I am around don't really care much about conference loyalty. They aren't impressed with the SEC title. They love the game, their Sooners, and some of the rivalries (texsucks being the greatest).
As far as game day, tailgating is not impressive compared to what people describe at UT and other SEC schools. OU just this past season re-opened the street in front of the stadium to tailgating, but with a ton of rules. They had shut it down for a few seasons, not sure why, but I think realized that to "compete in the SEC" they needed something. Maybe it gets better as time goes on.
Sooner fans are really very considerate, as long as the opposition is as well. LSU sh!t all over OU fans in the Sugar Bowl back in the early 2000's and have earned the hatred of OU fans. Texsucks fans have to be hated because they are texsucks. Everyone else gets treated decently unless they earn a bad rep. I doubt there will be many issues in the future. My friends who attended the OU/Tenn game a few years back had nothing but great things to say about how they were treated.
Norman is a great town, though other activities are somewhat dependent upon game time. OU has had so many 1100 am start times in the Big12 that it's been hard to be consistent with gameday activities on campus. OKC has really taken off in the past 20 years. Tons of stuff to see and do if you have a little time. As mentioned by some above Bricktown is a solid place to go. Lots to eat and see. The Oklahoma River is right near there and has some cool stuff as well. It's isn't fun, but the OKC Bombing Memorial is very moving and well worth the time. Tons of other stuff.