There is a humerous part in one of Alan Dean Foster's "Spellsinger" SF series when "Jontom" the erratic musical magician sings the song (probably the Beach Boys version). He wants to conjure up some transport and so thinks of a song about a ship but forgets about the lines saying that the crew get drunk and it's the worst trip he's ever been on.