Updated. The example by user Lucifer@Lucifer is completely correct. Thanks to user Count@Count Dracula who explained the example proposed by user Lucifer@Lucifer. That example is fine. I am keeping the counterexamples below, since they arise in a different way: as Severi-Brauer schemes over multiplicative group schemes over a field (and schemes mapping to such Severi-Brauer schemes). The counterexamples are given after a general statement that can (sometimes) be used to prove surjectivity of the morphism (1).
Setup. Denote by $S$ the scheme $\text{Spec}\ k$ (to save typing). As in Borovoi-- Colliot-Thélène -- Skorobogatov, denote by $\mathfrak{g}$ the Galois group $\text{Gal}(\overline{k}/k)$. Let $\pi:X\to S$ be a smooth, separated, quasi-compact morphism with geometrically irreducible fiber. Let $\sigma:S\to X$ be a section of $\pi$. Denote by $G_X$, resp. $G_{X,\sigma}$, the group $S$-scheme that represents the functor sending every fppfsmooth $S$-scheme $T$ to $\mathbb{G}_{m,X}(X\times_S T)$, resp. to the kernel of $$\sigma^*(T):\mathbb{G}_{m,X}(X\times_S T) \to \mathbb{G}_{m,S}(T).$$ Pullback by $\sigma$ defines a group homomorphism, $$\sigma^*:\text{Br}(X)\to \text{Br}(S).$$ Denote the kernel by $\text{Br}(X)_\sigma$. Pullback by $\pi$ defines a group homomorphism, $$\pi^*:H^2_{\mathfrak{g}}(G_{X,\sigma}(\overline{k})) \to \text{Br}(X)_\sigma.$$