Note that $F = dA$ is a $(0,2)$ anti-symmetric tensor field on spacetime (i.e a differential $2$-form). If you want to see how the components of this tensor field change as you perform a change of coordinates, you have to apply the tensor-field component transformation law. For example, if $(x^0(\cdot), x^1(\cdot), x^2(\cdot), x^3(\cdot))$ and $(y^0(\cdot), y^1(\cdot), y^2(\cdot), y^3(\cdot))$ are two sets of coordinates, then
\begin{align}
F_{(y), \mu \nu}&:= F \left(\dfrac{\partial}{\partial y^{\mu}}, \dfrac{\partial}{\partial y^{\nu}} \right) \\
&= F \left(\dfrac{\partial x^{\alpha}}{\partial y^{\mu}}\dfrac{\partial}{\partial x^{\alpha}}, \dfrac{\partial x^{\beta}}{\partial y^{\nu}}\dfrac{\partial}{\partial x^{\beta}} \right) \\
&= \dfrac{\partial x^{\alpha}}{\partial y^{\mu}}\dfrac{\partial x^{\beta}}{\partial y^{\nu}} F \left(\dfrac{\partial}{\partial x^{\alpha}}, \dfrac{\partial}{\partial x^{\beta}} \right) \\
&= \dfrac{\partial x^{\alpha}}{\partial y^{\mu}}\dfrac{\partial x^{\beta}}{\partial y^{\nu}} F_{(x), \alpha \beta}
\end{align}
Here, I use the notation $F_{(y), \mu \nu}$ to mean the $\mu \nu$ component of the tensor field $F$ expressed in the $y$ coordinate system.
So, what the above equation tells you is that if you know all the components of the field strength tensor field in one coordinate system, and you wish to change coordinates, then to find the components of that tensor in the other coordinate system, you apply the above rule (summation convention used throughout).
For this, there is absolutely no need for the metric tensor field. The metric tensor only comes in if you want to "raise/lower indices". So, do you want the tensor with two lower indices? One upper, one lower index? Or two upper indices? That's the only place the metric tensor field comes into play.
Btw, in your example, you have the term $C(r)\, d \theta^2$, but for spherical coordinates, it is $r^2 \sin^2 \theta\, d \theta^2$, so it should be $C(r, \theta)\, d \theta^2$ (of course, there are slightly different conventions for which angle is which, but my point is that the metric coeffcients in spherical coordinates do not depend only on $r$).