The exclamation mark is part of the title. I would say the hard stop goes at the end of the sentence otherwise the exclamation mark could be construed as part of the sentence and not part of the title.

You can think of an exclamation mark like a period that's had a line drawn above it; it takes the place of a period, rather than having both side by side.