While it is possible that it may someday come to consoles, it is not currently planned. Valve is a PC developer and while they have brought their games to consoles in the past, it has never been a priority for the Half Life franchise.
At the moment, Alyx is a VR only experience, which means that even on PC, you must use a VR headset to play it. There are mods that will allow you to play the game without a VR headset but they are not officially created by Valve. If Valve is unwilling to make the game non VR for PC, the chances of it being made for consoles where VR support is limited seems quite unlikely at the moment.