There's two sources of motivation: official and unofficial.
I assume that the coaching staff do try to make their preparation and practices "team-agnostic" whereby they focus as much as possible on the impersonal properties of the opposition to prevent biases from possibly undermining specific tactics and schemes that they want to install. So, the coaches would like the players to believe that Bama is not practicing to face "LSU"(a team whose very name brings various responses from players and coaches) , but instead is practicing to face a team that:
- has a QB that has been typically inconsistent during his career, but has talent and ability and seemed to be vastly improved earlier in the season
- has a new offensive coordinator that appears to be the impetus for this improvement
- has a couple of very good running backs
- has solid depth at the RB position
- likes to run inside most of the time
- has two outstanding receivers
- has a young, but talented defense
- has a defensive coordinator with many years of experience and a steady record of success
- has a head coach that is an oddity (to be kind)
At game time, the staff might have some particular motivational methods that are specific to the opponent, but I doubt that they want to use anything said by a player on the other team to evoke an emotional reaction because that could inadvertently lead to a personal foul or other undesired actions by our players. Typically, emotion only lasts for a few series and then preparation, discipline, strength, endurance, talent, and will takes over. The primary motivation is likely an entreaty to maintain focus at all times and to not be dazzled in the lights, intimidated by the situation, or befuddled by a feint. CNS repeatedly tells the players to trust their preparation, so I believe that he places a lot of importance on it.
Players individually may use statements by opposing players or coaches to self-motivate, but it's probably not a staple of the staff's last-minute mental preparation.