Does my sale price end automatically when the countdown timer runs out?

No. The Countdown Timer only shows the timer. When it reaches zero, the timer disappears from the product page, but your prices don't change.

Remember to remove the sale price (or switch off your coupon) when the offer ends. You can also set Starts at so the timer stays hidden until the sale begins.