The Astronomer CEO caught getting cozy with a coworker at a Coldplay concert on Tuesday has resigned amid an investigation into the scandal.