There's pretty much an hourly train service from Tarbes to Pau, if you need to go there: it takes an hour. The SNCF are pretty good at allowing bikes on trains, so you could quite easily get to a rental agency in Pau.
But yes, a lot of things close round there on Sundays. Even in Paris, there's not much open...