Cost
Service upgrades tend to be expensive, since it usually involves installing a new service panel. Depending on your situation, you may find that the cost far outweighs the reward. If you already have 100 Amp service, and you haven't added on to the home, you may find the upgrade unnecessary.
Availability
The upgrade has to be supported by the existing infrastructure, otherwise the provider may charge you to upgrade their system. Just like the wires in your home have to be sized properly to carry the load, the distribution wires also have to be capable of providing the extra power. If the distribution system is at, or near its limit, the provider will have to make upgrades to the system before it can offer an upgrade to you. In this case the provider will either tell you it can't offer you the service, or they'll offer the service but only if you pay extra to help offset their costs. This is not a common scenario in most large US cities, though can still be encountered in less populated rural areas.
That Federal Pacific panel has to go as they are dangerous. As far as concerns about your skill, you sound like that particular kind of newbie who is well capable of learning to do it all safely and well; however my hunch is you are still thinking too much, and need to read a little more. It's OK, we all start there.
Normally, just replacing a sub panel is a straightforward thing. Change panel, reattach wires, done. However, this is only part of a project with a much larger scope. You must contemplate (i.e. ask your permitting authority) whether you have crossed the legal threshold of a remodel. If you have, everything in-scope must be done to all current codes. Even ADA!
The 2-circuit requirement for kitchen outlets is not intended to mean "1 circuit for this wall, 1 circuit for the other wall". I'd encourage some more research but if it was me, I'd interleave the outlets, every other outlet on a different circuit. Also there's nothing wrong with more than 2 outlet circuits in a kitchen, the whole point is to prevent trips when the chef is madly at work, so the chef isn't hobbled with limitations like having to put the toaster here and the George Foreman over there, and avert ugly workarounds like extension cords draped across sinks or stoves, etc.
I see you plan to go 12 AWG wire for almost everything (that's what 20A breakers mean) - that's awesome. Feel free to kick the refrigerator and smoke detector up to 12AWG also - that way you don't have to buy any 14AWG wire. I don't own any! If you have some other reason to use a 15A breaker you are welcome to use that on a circuit wired in 12AWG.
You may want to run the water heater circuit in 10/2 or even 8/2. That will allow you to easily upgrade to an electric water heater in the future. Still use a 15A or 20A breaker because the outlet is still only good for 20A. There is a trick to fitting 8+ AWG wire on a 15-20A outlet, just ask.
I would go with a much larger panel. You have either -1 or 3 circuits left, and that's too little headroom for my comfort. Getting a larger panel is dirt cheap compared to the cost of replacing perfectly good breakers with duplex breakers (I call them double-stuff) merely to shoehorn everything in. Also, larger panels in combo-packs come with more breakers and that is far-and-away the cheapest way to buy breakers. Another reason to avoid duplex breakers is if you ever need AFCI, GFCI or whatever future thing comes out - those are much more expensive in duplex breakers because of the miniaturization required. Don't think you must use a 100A panel - you can use a larger panel (200A), you just can't use a smaller one (70A).
Remember each sub-panel must have its neutral bus bar separate and isolated from its ground bar. That means removing bond straps, magic green screws, neutral bar kits, whatever the panel requires to do that. You might consider a panel with a neutral and ground bar on each side of the panel. That's a convenient feature so wires don't have to cross over the panel.
Keep in mind how your house got a dangerous Federal Pacific panel. The last guy bought cheap. Feel free to research the good-better-best that each manufacturer offers, the price differential for "best" is quite small compared to the overall cost of a remodel. You may find better selection and better prices at a real electrical supply house.
There is nothing wrong with more ground rods. Go nuts. The key is that all the grounds are connected to each other by wire - and they are not connected to neutral anywhere except one place - the main service panel.
Best Answer
Apart from what code requires, there are various things that you might choose to do, depending on your mindset, that are not code required (nor do they conflict with code.) For instance, I prefer to keep all lighting circuits completely separate from any outlet circuits, having basically never had light fixtures blow a fuse/trip a breaker, but having stumbled though the dark to the fusebox (yes, literally, fuses) too many times once upon a house when outlet overloads took out combined circuits (I think there were a total of 6.)
i.e. you have chosen to give the microwave its own outlet. I prefer that the refrigerator also not share (I don't recall if code does that), code requires two separate 20A countertop outlet circuits, and I'd also put a separate light circuit in the kitchen (that might share with other rooms' lights, depending on load.)
Likewise code has some specific language and requirements for bathrooms, primarily hair-dryer-driven.
Remember that code specifies the minimum you must do; it does not limit what you do beyond that, so long as what you do meets it.