On the first page Gisborn posted what you can get from gacha tickets. The Answer is: Only Jormungadr and Thundrous Warhammer are SSR.
So about ragnarok raids... Is it really worth joining them even if you won't be mvp? I mean it sure does looks like it's worth it. Besides mvp just gets 4 more chests, so not losing too much not being it.