Chiral $p$-wave superconductivity in twisted bilayer graphene from dynamical mean field theory