Generally speaking, players of other sports in a given city typically support the other hometown teams. There are exceptions in some cases, with Mike Trout's hometown Eagles fandom a famous example, but you generally don't see opposing fandoms flaunted too much, especially in season. However, Houston Astros fans were treated to a minor betrayal over the weekend courtesy of Texans quarterback CJ Stroud.
Obviously, Stroud is a big name in football circles after getting picked second overall in 2023 and going on to win Offensive Rookie of the Year. Football is big business in Texas, and with Stroud, it looks like the hometown Texans are going to be a force to be reckoned with for a long time.