Detection prospects of core-collapse supernovae with supernova-optimized third-generation gravitational-wave detectors