I see five days of travel for your entire trip: Frankfurt to Bacharach, Bacharach to Rothenburg, Rothenburg to Munich, Munich to Hohenschwangau day trip, and Munich to MUC. In Munich, a rail pass would cover the S-Bahn to the airport, but not any other transport (U-Bahn, trams, or buses) to get to/from the S-Bahn.
For Frankfurt airport regional station to Bacharach you can purchase two RMV (Frankfurt metro) tickets at the airport station for 12,20€ each (24,40€ total).
For Bacharach to Rothenburg, you can get a Savings Fare, advance purchase ticket online. For a lot of dates, I see 55,80€ tickets for two with three or four changes. Connections are at least hourly. Most trips take 4¾ hrs. Even without the advance purchase, Bacharach to Rothenburg for two people is only 128€.
For Rothenburg to Munich and for the day trip to the castles, a 31,-€ Bayern-Ticket each day would suffice. The Bayern-Ticket would include the bus from Füssen Bhf to Hohenschwangau, but a rail pass would not. Oh, well, the bus costs only a few euro per person each way.
And, finally, anywhere in downtown Munich to the airport would be 11,60€ per person (23,20 € for two).
You don't want a car in Munich. Parking is expensive and MVV fares are low. You might spend more for parking than you would to use public transportation. An all day pass for two (up to 5, really) in the innerzone of Munich costs 12,80€.
So, I get a total price for five days of travel using the trains of 165,40€. RailEurope charges $450 (about 390€ at today's exchange rate), so a 5-day German Rail Twin Pass is at least twice what you should pay for Bahn and local tickets. Even without the Saver Fare, point-to-point tickets are only 237,60€, so you'd still be $175 ahead.
As for renting a car, ViaMichelin estimates the gas alone for a compact car for your trip at almost 100€, so where are you going to rent a car for $75 a week?
So, I think you can see that the trains in Germany with point-to-point tickets beats either a rail pass or a rental car. And, besides, in this country to get almost anywhere, you have to go by car. Using trains is something you cannot experience here.