C++ is essential for consoles (at least the 360) if you're not going the XNA route. Moreover, you have to compile with vendor-approved compilers, link with the vendor-provided libs and use approved graphics functions (e.g. DirectX on the 360).
Of course, many console games use Lua for scripting. LuaJIT, however, is not supported on consoles.