One way to look at it - World Series winner past 10 years, and their regular season ranking in HRs
2021 - Braves, 3rd
2020 - Dodgers, 1st
2019 - Nats, 13th
2018 - Red Sox, 9th
2017 - Astros, 2nd
2016 - Cubs, 13th
2015 - Royals, 24th
2014 - Giants, 17th
2013 - Red Sox, 6th
2012 - Giants, 30th
With the exception of 2020, the top HR team didn't win it all.
Then you get into regular season vs. playoffs, and matchups. I think if the lineup is too one dimensional, your regular season HR hitters will have less success in playoffs. Pitchers will be more cautious and focused on avoiding the big play.