well its an orca whale's penis...and yes that is an accurate picture

http://www.rockisland.com/~orcasurv/behavior.htm (click on the 'seasnake' link for another pic)

but as to it being a turnon? you'd have to be extremely open-minded, not to mention flexible and probably you'd need to be able to breathe underwater so you don't die mid-coitus.