Playing without raiding
There's a lot more to Classic than just endgame raiding, although it must be admitted that raiding really is the core endgame of classic. This isn't an exhaustive list but here's everything I can think of off the top of my head which you might want to try instead:
As others have pointed out, what exactly is it that makes you not want to dabble in raiding? Is it because you don't have enough time or fear that you won't be able to contribute to the group? Or is it simply because you prefer to play alone?
So much this! And I would like to add something to point 2:
Not only are the professions heavily involved but also for people that don't raid very rewarding. Some of the better gear outside of raids can be crafted.
I know someone who is playing just to explore and make money. Kind of like a Marco Polo type...