Where can I find scripture that answers the questions Asaph poses in verse 10? Also, your input on Psalm 74:9–11 is welcome.

I will answer your first question first. It is found in Revelation. In chapter 16:9,11, and 21, they blasphemed or cursed the God of Heaven and wouldn’t repent. The refusal to repent is also found in Chapter 9, but it doesn’t say they cursed or blasphemed. Asaph’s question is answered in Revelation also. At some point everyone does stop blaspheming God and praises Jesus instead here: Then I heard every creature in heaven and on earth and under the earth and on the sea, and all that is in them, saying: “To him who sits on the throne and to the Lamb be praise and honor and glory and power, for ever and ever!” Revelation 5:13 Also Paul tells us this: Therefore God exalted him to the highest place and gave him the name that is above every name, that at the name of Jesus every knee should bow, in heaven and on earth and under the earth, and every tongue acknowledge that Jesus Christ is Lord, to the glory of God the Father. Philippians 2:10-11, mirroring what happens in Revelation, outside of time and space.

To group all three verse together, all three questions are fulfilled with the coming of Jesus to the earth. He is the Prophet, foretold by Moses Acts 3:22-23. He gave us all the Signs and Wonders, Acts 2:22, and He was seated at the Right Hand of the Father to intercede for us night and day forever Romans 8:34.