To be “on the team” or “in the team” (you can use either) means to be part of the team (ser seleccionado para el equipo). To “make it onto/into” the team means that you were selected to be a member of a team, for example in a football team the manager or coach decides who will play in the next game. So if someone didn't make it onto/into the team, it means they were unsuccessful in their attempt to be part of the team.
You could also use it to refer to other things, such as universities (“I didn't make it into the Universidad Autónoma de Madrid, however I made it into Complutense”) or transport (“I didn't make it onto the 17:45 train from Atocha but I made it onto the next train at 18:15”).
It means you were unsuccessful in an attempt to do something.