Andy Byron resigned as CEO of Astronomer after a viral Coldplay concert video showed him in a compromising moment with HR executive Kristen Cabot.