I think that, in the show, Scootaloo has given up this dream and is trying to find another way to soar. It's sad but it really is wonderful how Rainbow Dash, who seemingly ought to be the symbol of everything Scoots will never have (and thus ought to be a walking, talking and flying torment for the younger pegasus) remains a meaningful role model.