I'll let you decide what should have happened to Brock Long.
Brock Long is still the FEMA administrator. Here is a Washington Post story, Brock Long’s improper use of FEMA staff, SUVs included Hawaii pineapple plant tour, investigation says.
The story above has a redacted version of the DHS IG report linked in the document.
For me, the biggest issue is that he was informed/warned that the usage was not authorized. Perhaps he got bad advice or perhaps he just plain ignored that information — to his detriment.