If Speed sensor is the only problem, you don't need to change it
You would not get an accurate mileage reading. But it should not affect your transmission.
Before you do your annual emission inspection, reset your computer by pulling the fuse. That little trick might buy you enough time to just pass the test.