Sport mode changes the shift points which means two things. Your fuel economy will suffer in trade for better performance. Tires may wear faster but it will be negligible unless you really are the kind that accelerates hard from a dead stop. That's it. The transmission will not be worn out any faster in sport mode that it would be in normal mode and no, the engine should also have no issues revving a bit higher between shifts..