From the looks of it, you can actually take a train from the TGV station at CDG that will at least take you all the way to Bordeaux. From there you may have to make another transfer or two to get to Lourdes, but at least you won't have to go into Paris to catch a train. If this is the case, you should be able to clear immigration and make your way to the station in 2 hours (granted that your flight arrives on time). If you had to go into Paris to catch the train, you'd be cutting it close. Check here for schedules and fares (be sure to enter CDG for departure point): http://www.sncf.com/en/passengers
As for flights, it appears there are only flights between Orly Airport (which is all the way in the south of Paris) and Lourdes, so a morning flight really isn't reasonable. You could spend a few hours in the city if you don't mind carrying your luggage around if you were keen on seeing a bit of Paris and then head to the airport for the afternoon or evening flight. Otherwise I think taking the train directly from CDG is your best option.
Additional: The Flexible fare is only exchangeable and refundable up to 2 hours after the departure of the train, so a serious delay still means losing the ticket.