Story wise, it was actually like something that Roddenberry would come up with; in terms of how it was executed, it just fell a little flat.
That's a good recall, homer. Spock's "talking to the whale" just came back to me, too; the kid's reaction to his mother was funny, I guess. Seeing the crew interact with modern day America was somewhat comical, and watching Bones cure the old woman with kidney failure was good, too, I suppose.
Maybe it wasn't totally forgettable; maybe I'm just getting forgetful.