Meaning a game console that can not connect to the internet like any console released before Dreamcast (Im not counting X-Band)

Not wanting to debate the merits of whether the idea is good or bad but simply the liklihood of it ever happening.

Im going to say "yes" given all the pushback to online connectivity. I think it will come in the form of a crowd funded project and if that is successful, Nintendo may do something offline that would be a companion to their main console that would still be online. And then maybe Sony and Microsoft could follow suit