Honor your father and your mother, that your days may be long in the land that the LORD your God is giving you.(Exodus 20:12 ESV)
As a parent this is a great prayer topic! It clearly also links with obedience (Ephesians 6:1-3), but obedience can occur grudgingly without real respect or honour.
Respect has to come from the heart. To an extent a parent can ‘earn’ or destroy respect (see Ephesians 6:4). Yet we can choose to give honour to a person in authority because we respect their position, despite what we may consider unworthy behaviour.
So whether I deserve it or not, as a father it is good to pray for my children to respect me because for my kids to respect their parents is good for them.