The entire Brian Wilson/Jodie Foster SNL episode is available for streaming.
http://www.hulu.com/watch/159671/saturday-night-live-jodie-foster-and-brian-wilson#s-p3-n2-so-i0Say what you will, I think he sounded awesome on Good Vibrations and Back Home considering some of his other performances at the time.
He does however look awkward in the sketch they put him in, though it is a funny sketch. It is an overall good episode, better than Saturday Night Live has been recently.