The Honda rider saw his front row hopes dashed at the death as he ended up in the gravel on his final flying lap