Reddit reviews Becoming Fluent: How Cognitive Science Can Help Adults Learn a Foreign Language (The MIT Press)

Hey!
First, props to you for deciding to brush up your French language skills sooner rather than later. Learning a language is all about the long-term, so the sooner you get to it the better.

There are already some good resources posted in this thread, but in my opinion, Duolingo would probably be a better fit for your skill level than Rosetta Stone. Rosetta Stone tries to emulate the way children learn their first language, so you never really learn grammar/syntax/other rules explicitly, and it's all about repetition. I've yet to meet a single person who didn't get bored with it in a matter of weeks. It's decent if you're just starting to learn a very foreign language with different alphabets and sounds like Mandarin or Arabic, but that's pretty much it. You might want to check out Becoming Fluent by Roberts and Kreuz for information on adult language learning from the perspective of cognitive sciences. I thought it was very interesting and useful (not too long either)!

Once you've refreshed your high school French grammar memory, I would just go straight to consuming French-language media. Watching movies/TV shows with dubbing/subtitles is always a good option. I would prioritize Quebec productions if the goal is to become familiar with a spoken French that is closer to what you would hear in every day life. Nearly the entire catalogue of Radio-Canada's French-language TV shows is available for free on tou.tv. You can also find just about every podcast in Quebec on baladoquebec.ca. You could even rewatch classic cartoons like King of the Hill and The Simpsons in French: the dubbing for these two shows in particular has been done in Canada with adaptations for a French Canadian public and it's actually well done. These two are some of the few TV shows that are arguably made better by the translation. If you have to commute to school/work, I would recommend filling your playlist up with French podcasts and audiobooks. I've found some French audiobooks for free on audiobookbay before, but I'm sure it's also possible to buy/rent audiobooks legally too^(if you're a square) ;)

As for real-life practice, Fredericton isn't the best city. But there is a small Francophone community whose activities seem to be centered around the Centre Communautaire Sainte-Anne. Some events are posted on the Centre's website, and it looks like you can sign up for newsletters, classes, etc. It also houses a French-language library which might come in handy if you can't find a lot of French resources in the city library.

As for not wanting to seem "like a bumbling idiot", I say don't worry about it. Francophones in NB rarely if ever expect Anglophones to address them in their language, but they are always glad to see someone trying (probably even more so in our current political climate). Just a word of warning though: don't be offended if you ask a Francophone a question or whatever and they switch to English. It's not because they can't understand your French/accent, but rather as a courtesy and a habit. In a situation like this, don't be afraid to just let them know that you're trying to practice your French, and they'll happily oblige.