Moranis said he's now more selective, and Spaceballs 2 will be his first on-camera theatrical feature since 1996, though he continued to do voice acting for years afterward