I suggest you contact your nearest NI office for further support since Academic product line is a little different from standard product line and the product suitable for your needs may vary depending on what you would like to do further.
That being said, the simplest module for CAN would be USB-8502. It supports High speed CAN, CAN FD, and J1939 and not CANOpen.
Do you have any practical reason why you want to use CompactRIO? Do you already have cRIO?
If you want to use cRIO, then regular CAN would be 9862 or 9860 and CANOpen module would be 9881 as you mentioned.