No, Roadsters cannot charge at Superchargers. Roadster charging is AC only. Superchargers are DC. If you use the CAN-SR to connect to a Supercharger, nothing will happen.
Yes the CAN-SR will allow Destination charging without an account, UNLESS, the wall charger is part of a “Charging Network”...