Any apology video is going to get a tiny fraction of the views the original gets. Why not make your apology when people still have the video fresh on their mind? As far as I'm concerned, he only needs to have sobered up to be able to apologize coherently. If he waited months or something, he'd get even fewer views on the apology.
And people would accuse him of trying to "stay viral" or something if he did it later too. He's in a no-win situation no matter what. It's a no-win situation he created for himself, but let's not act like there's some best course of action that would actually win people over.