Calif. cop involved in shooting of college football player resigns in disgrace over ‘disgusting’ racist texts