So after about an entire days worth of farming, I can say that this new raid drop system isn't as bad as what others seem to have thought when the event started.

Ragnarok drops are rather good. 1 to 2 red souls, even 3 if you start your own, with more than 2 soul fairly common and a load of tickets if you MVP or contribute enough. Easily a page worth of drops. Like 8 to 10+ tickets.

Expert drops 1 to 2 blue souls if you join. Maybe 3 if you create your own? I'm not too sure about that since I mostly just joined others. Expert ticket drops however could use some buffs. I never got more than 5 drops from expert joining as help but in most cases it's just 3 or 4 drops with 3 being annoyingly frequent. Usually 1 to 3 tickets and 1 to 2 souls. This is pretty terrible for ticket farming since you're spending 2 BP for 1~3 tickets while ragnarok is 4 BP for triple or more tickets of what you get from expert, easily making up the double BP cost.

So if you're done with the event and still want to farm stuff from raid gacha, best to completely ignore joining experts. Starting your own is probably okay if you solo and want items to start a ragnarok but joining an expert is just a waste of seeds or BP if you don't need the blue souls since the ticket gain is just terrible. Of course the matter of whether or not you can consistently MVP or contribute enough plays a part in this too.