they show plenty of an accord/inspire running around a track in that SH-AWD video, but that doesn't mean they actually made an accord with SH-AWD - even a prototype. the video is just for demonstration purposes, to explain the technology.

i think they may eventually create an AWD accord - but it'll be in some version of the JDM/Euro accord. it may make it into the TSX as well, but the regular USDM honda accord will probably never have it.