Weyl Formulae for Some Singular Metrics with Application to Acoustic Modes in Gas Giants