Exactly think of the TS as a building. Inside the building are many rooms - compartments, special accesses, etc. Getting a TS just gets you in the building, it doesn’t mean you can go into every room. The job you’re assigned gives you a ‘Need-to-Know’ which may get you into several rooms but you’re not going to know them all. The DOD, DOE, State, Fed LEO & IC manage their TS (with some small differences in management) and who gets into what rooms and why. There is cross organizational cooperation on this as the specific job may require.
In my day the SCI endorsement was the ticket to have.
A TS clearance just wasn’t enough for many jobs.