Why heavy end-on batteries declined in sailing warships

How common were large bow or stern batteries, like those shown in Pirates of the Burning Sea?

It depended on the period; heavy end batteries had uses in pursuit, but became less attractive as broadside fire grew more dominant.

Heavy bow and stern batteries offered useful fire during pursuit and other end-on engagements. Their prevalence depended on the period and the priorities of a navy or designer. As side batteries grew more powerful, the expectation of a broadside action reduced the attraction of carrying a large forward battery. Guns reserved for end-on fire then represented weight that contributed less in the main engagement. The game example prompts this general explanation without establishing the historical accuracy of its particular battery.