Common envelope evolution: From binary star chrysalis to cosmic butterfly