Short answer: ADSL can still be relevant where newer networks are unavailable, but it is usually slower and less consistent than FTTC, FTTP, and strong mobile alternatives.
When ADSL may still be practical
Your property has limited upgrade options at present.
Your usage is light and does not require high upload performance.
You need a temporary fixed-line route while awaiting network upgrades.
What to verify before ordering
Realistic speed range for your line, not theoretical maximums.
Upload and latency fit for calls, remote work, and cloud use.
Total contract value compared with available alternatives.