Don't own an RV, so no direct experience. But I did once park my car at the Ag campus and caught the free shuttle bus to the stadium from there. So a few observations:
(1) I mentioned this already: the shuttle bus to and from the game is free. So that's nice.
(2) The RV denizens seemed happy, relaxed, in good spirits. So they seemed to be enjoying it.
(3) The parking I could see is all right there in the parking lot. So a football field+ of asphalt. It's not like you're pulling up in a nice wooded spot by a lake shore. I guess kind of the urban version of RVing.
(4) Seemed like a community: like a common area was set up between three or four of the RVs with all the camp chairs and I think a picnic table.
Anyway, that's all I know. If you're looking for idyllic wilderness camping, you'd be disappointed. If you're looking for convenience to the game, I think you'd be pleased. No idea how it measures on things like noise while you're trying to sleep or anything like that. Didn't stick around after the game. We lost to Arkansas that night.
Hope this helps a little.
Go Vols!