The Bible indicates David will be raised up by the LORD God to also rule over Israel. That could be symbolic of Christ Himself, being from the line of David; or, it could be that David himself will literally have a role to play in the kingdom.
Jeremiah 30:9 But they shall serve the LORD their God and David their king, whom I will raise up for them.
Ezekiel 37:24
The Davidic Kingdom
24"My servant David will be king over them, and they will all have one shepherd; and they will walk in My ordinances and keep My statutes and observe them
Ezekiel 34:24
24"And I, the LORD, will be their God, and My servant David will be prince among them; I the LORD have spoken.
Hosea 3:5
5Afterward the sons of Israel will return and seek the LORD their God and David their king; and they will come trembling to the LORD and to His goodness in the last days.
Since Jesus and YHWH are synonymous, I don't think we can say that the literal David will not have a role to play. Ultimately, Israel will serve the LORD her God. But, David may have a governing role.
Psalm 110:1
The LORD said unto my Lord, Sit thou at my right hand, until I make thine enemies thy footstool