No it's does not feature any explict unsimulated sex.
Collins is shown in the end putting Snowman in cell no 13 along with Danny Samson, whom he had betrayed. At the same time, the portion of John Smith's letter, "The prison desensitizes you", is read in the background.
That implies that Collins will get on with his prison duties just fine.
