He gets lost amongst his teammates because he's the kicker and Kelce and Mahomes take all of the headlines.
I think it will be forgotten after a week because you really overestimate the attention span of the general public :/
The NFL can cut ties with him if need be, without ever having to reference it's about his bigotry. NFL player contracts basically operate that way. The player is bound for as long as the team wants him to be. The team is bound only as long as it cares to be.
The team will keep him around because he's useful when that no longer happens they will dump him. Like they do every other player who doesn't produce.