How much of that order is for things the Navy actually needs?

All of it :)

Here's the best info I can find on it:

cdrsalamander.substack.com - What are the details for battle

I thought by now I’d find a “Ref. A” for those numbers, but no joy. So, I reached out to a real professional and friend to the blog (who will remain on the DL) for some help. Trust me on this—if anyone can figure it out, he can.

Even he admits that it’s hard to find the numbers. The biggest issue is that the only budget document for ships we can get ahold of right now is the Department of War’s Procurement Programs (P-1) Brief for fiscal year 2027.

Here we go. The battle force ship list is below. I've added the ship class for each:

1 x Columbia SSBN (Columbia, obviously)

2 x SSN (Virginia class nuclear fast attack submarine)

1 x DDG-51 (Arleigh Burke class destroyer)

1 x FF(X) (the Navy's version of the Coast Guard's Legend class cutter)

1 x LHA (America class, essentially a light aircraft carrier)

1 x LPD (San Antonio class amphibious transport dock. You just saw one of these (USS John P. Murtha pick up the Artemis spacecraft)

1 x T-AGOS SURTASS (New Explorer class. These ships carry massive towed array sonar for ASW purposes)

2 x T-AO (Fleet replenishment oilers)

2 x T-AS(X) (Submarine tenders)

6 x LSMs (Landing ship, medium)

All very useful stuff...for Pacific Ocean operations. This stuff plus the stuff below is how you move Marines around.

The non-battle force list:

1 x special mission ship of unknown capability

1 x strategic sealift (new)

4 x ship-to-shore connectors (LCAC 100 class, a really big hovercraft)

2 x LCAC SLEPS

1 x bulk fuel vessel

5 x fireboats

1 x sealift vessel (used)

1 x T-AH (Hospital ship)

Freaking. Cool.
Finally someone in DC is paying attention to what the surface Navy actually needs.