There tidal bore viewing spots in Moncton right along main roads. These would not require a lot of walking. Check out what time it is schedule to occur and then arrive at least 30 minutes early-times can vary somewhat. Be prepared-sometimes it's very small but still interesting to watch the tide come in that way. While the viewing at Hopewell Rocks doesn't show the actual wave, it is mind-boggling to watch how swiftly the water level rises. You will be pressed for time to do much in either NB or PEI if you choose both as I am assuming you will take two days to get there. That said, I would take the bridge both ways. Definitely go to Charlottetown as long as your FIL isn't completely immobile. It's a great place to just wander around. You might want to consider renting a wheelchair (if he doesn't have one) to increase your ability to visit.