@Prof_Smash, is your sprite component set to Static mobility by any chance? (Look at the component near the Position/Rotation settings) If so, changing the mobility should allow the SetSprite call to work as expected. You will also be seeing a message in the Output Log about being unable to change the sprite on a Static sprite component.
Cheers,
Michael Noland