If I remember correctly the visiting team ( and it didn't matter who it was) had a decent percentage of the crowd rooting for them. When SF went there it was a sea of red all around the stadium.
I doubt they have a letdown against the Titans. They will want payback for last year. They could lose but It won't be because of a letdown especially since its the home opener.