“The Torah says “Honor thy father and thy mother.”
What are the sources, should any exist, mitigating or limiting that all encompassing commandment (one of the ten commandments)?
Any such mekor? “
Yep, it also says in the Torah, “Ish imo v’aviv tira-u, v’es Shabsosai tishmoru,” a man should be in awe of his mother and father, and keep the Shabbos. Very strange second part of the sentence to be attached to the first. What has one thing to do with the other? So Rashi explains that although we are enjoined to respect and hold our parents in awe, if our father commands us to be mechallel Shabbos, we do NOT have the obligation to listen to him. That is the mekor. We have certain obligations to our parents, but when they tell us to do an aveira, we do not have THAT as an obligation. You continue to show respect to your parents in all other areas, though.