While it was a dumb move on his end to do, he probably should just have a good talking to and let that be the end of it. But sadly in the WWE, if someone higher up than you takes something personally, then you can bet it will be BLOWN out of proportion.
Seriously, he knew what he did was a mistake and he took it back almost immediately. I think having a night of not being able to sleep and thinking "Oh God, what have I done, I may have put my family's future in jeopardy with that tweet!" is more than enough punishment.
Now I hear they might be putting him in the Rumble as a "hazing". Which honestly sounds like more of an award because he managed to score a spot in the Rumble on PPV no less.