Game showing red ping on the top of the screen every few seconds

Look at the connection quality report here and match history see how your connection looks. You can also play the game with the input overlay one controller will show your server connection the other will show local. You can always show those tests to your isp. The last user did that and his isp fixed it. Could be a server issue too if enough report the same issue.