Max transition is the transition for the highest load which is characterized in the library. it is associated with the output pin of the cell. this tells you that the max transition that is allowed at the pin. it has nothing to do with the frequency. the output transition will depend on the input transition and that you have to transition of the pin within the bounds of max transition.