I used to play it a lot and I sucked at it so I think I'm qualified to answer your questions.

Yes, it's not very noob-friendly. Counter-Strike: Source is more noob-friendly vanilla CS, but it's still no cakewalk (BTW, if you're new to series, just skip CS and go straight to CS:S. Vanilla CS is full of hardcore CS enthusiasts, and is for masochists only.) No one's going to want to help you learn the ropes, and there are a lot of people that are really good at it and they will shoot the top of your head off before you even see them, and they will call you a distinguished mentally-challenged Jew monkey distinguished effete fellow when you fail. If you tough it out through your first few matches, it's not really that hard to figure out the basics, and there are always a few other awful players in public servers for you to get kills from. Just find whoever seems to be the best guy on your team, and then follow him around and see what he does.
Yes, if you die you have to wait until the end of the match to respawn. Matches usually don't last very long though. If you die right off the bat, you might have to wait a few minutes to respawn depending on the map, but after a while you learn to be more cautious, use cover better, and not get killed so easily. If you're a n00b, you should probably just hang back at the back of a group. You might be tempted to rush in Quake-style and get some frags, but that's the quickest way to get yourself killed. If you're defending, you should just find something to guard. If you're attacking, just hang behind a group of your comrades and wait for them to attack first. You'll learn the game soon enough, although you may never master it. Either way, it's worth $10.