Nope. That’s the elementary school reading of Nietzsche.
Now to what ol’ Friedrich was actually getting at. He was saying that all knowledge and progress is from a perspective, and furthermore was observing that with the loss of binding religion that had pervaded all culture, we’d need to create new horizons and values, of many different kinds, all instantiated by and for humans rather than handed down from some higher power or metaphysical authority.
In other words, we must become the god we killed; Nietzsche was not saying all hope of a shared future or futures was lost, but that now we were wholly in charge of creating any of that.
As I’ve said before, the philosopher Baby Queen understands Nietzsche better than most people who read him, including Nils Gilman.
You’re right that Nietzsche’s madman follows his observation about having wiped away the horizon by asking, “Shall we not ourselves have to become Gods, merely to seem worthy of it?” And this could be taken as a call to action, as you say, to seize the agency to become as Gods. But Nietzsche’s mad alter ego then observes, “I come too early. I am not yet at the right time. This prodigious event is still on its way, and is traveling.” So yes, eventually, we will need to re-invent ourselves as gods, but we are not ready for that yet (or weren’t, anyways, in Nietzsche’s day, in his estimation), and in the meanwhile, we live in a world of epistemic relativism. Indeed, I don’t think we’ve made much progress since Nietzsche made those observations: the ongoing epistemic crisis (lack of epistemic consensus) is the indicator that we are not yet as Gods.