Kylian Mbappé has admitted he “hit rock-bottom” after missing a crucial penalty for Real Madrid earlier this month.