Do people still play Battlefield 1942?
The answer is yes. Since the initial release though, some problems appeared, and were solved with fixes. As this post on EA Answers states, there are some patches that need to be applied in order to play the game (all needed info is on that link).
If you seek a general list of all available servers, you can use this search on Game Tracker :
BF 1942 servers.