Hi hi,
Welcome to the forum dustmite. Best advice I can give you is: Don't worry.
One of the great things about pipe smoking is the variety. Captain Black is a fine tobacco. If for whatever reason you don't love it: Don't worry! There are 100's of other options that won't break your bank. I happen to like to smoke Smoker's Pride vanilla cavendish when I am putzing aroud the yard. The stuff costs $15.50/ 12 oz even here in evil WA State.
If you get a pipe and you don't truly enjoy it: Don't worry! Chances are once you are here a bit, you can sell the thing off to one of us and buy another.
You are right to keep on eye on your wallet. Start with Cobs from Missouri Meershaum if you are broke. A bag of 10 smokable seconds is like $29.95 right now and the website is located to the left under site sponsors. If you don't like cobs: Dont Worry! You can gift them to friends and stuff as you expand your circle of pipe smoking buddies without breaking your bank.
It isn't even fair to advise you on what brands to look for when looking for a briar pipe. There are just so many. You will do fine with a Grabow or Carey. Many will have you jump a step to the big factory pipes: Savinelli, Stanwell, Peterson. Still others will offer the lesser mentioned but still good factory pipes: Brigham, Butz-Choquin, Chacom, Nording, Neerup, Rossi (good choice, since it is basically an even more affordable Savinelli), or Ropp.
Seem a bit overwhelming? Don't worry. The guys and gals on this forum will gladly answer any questions you have and help guide you on your path.
Best of luck to you and we hope to see you on here for years to come!
Mike