I don't think MLB wants to make a big scene about it since they get so much money from sports betting.
If it ends up just being a wire transfer for his friend I think the punishment is going to fall well short of "screwed". I'm guessing he'll plead out on the crime and end up with a fine and MLB will give him a short suspension.
If he ends up actually being tied to gambling, yea, that will be a huge blow for MLB and if they have any sense (past history shows they don't) they will cover it up.