When are you coming down?
The next New Orleans Pipe Club meeting is Wednesday, Sept. 21 at Mayan Imports in Metairie.
I wouldn't suggest one of those rent-a-bikes for the trip because of the traffic. Lyft and Uber are in New Orleans so they would be a better choice or you could take a taxi but check on the cost first. It's probably about seven miles from the Superdome to Mayan Imports in Metairie but it is across parish (county) lines so the cost may be higher than Uber.
You didn't say where you were staying. If it's one of the downtown hotels, check with the concierge they may be able to help you.
The main Mayan Imports location is actually the one of Magazine St. but it is more "cigar-centric" than the one in Metairie. The last time I was in that location, they did have a few pipes and tins of tobacco but it was more limited. They also had a small smoking lounge area. I haven't been to that location in years though because I personally have no reason to go into that part of New Orleans.
As for transportation to it, there are taxis, Uber, Lyft and the city buses.
Depending on your time and interests, I would suggest you take a day and visit the National WWII museum. It's fascinating and covers parts of two blocks. It takes pretty much five or six hours to do the visit justice.