In this case, I think of and in are both acceptable, but I would favour of.
In more general sense, a person or thing of a collective noun implies that the noun is constructed out of a collection of such members. Something in a noun is more general, the noun might exist separate from the people or things who are included in it.
When you say
He is the most committed person of the club.
you are emphasizing that the club is just a collection of people, while
He is the most committed person in the club.
emphasizes that the club exists separate from its members.
In most cases, either in or of is acceptable, but there are stylistic preferences. Member is nearly always followed by of because the word implies a constituent part of a group. Similarly, group is nearly always preceded by of because a group has no identity separate from its components. And of course, if the group is described using a plural instead of a collective noun, then always use of:
She was the youngest of the players.
Superlative adjectives wouldn't change the basic distinction between of and in, but the distinction creates the potential for different interpretations of an adjective.
She was first in the team on the racetrack.
implies that, in the ranking of all team members based on race results, she came in first.
She was first of the team on the racetrack.
implies she was the first person of the group to arrive at the track (although I would still recommend re-writing the sentence for greater clarity). I can't think of any similar confusion about the adjective youngest.
As mentioned by others in comments, "on the team" is another alternative, and probably more common than "in the team". However, that wording is really specific to team, perhaps as an extension of the idea of a team as a list of names of people who made the cut. You can describe a person as being "on a list", but not "on a group" or "on a class".