The bard seems to be solid, after giving it some thought. I will miss Song of Rest, but I think it's still over-all an improvement with the changes to Bardic Inspiration.
Magical Secrets class restrictions do not seem necessary, in my experience, but I don't think they hurt the class either. There are plenty of spells in the cleric, druid, and wizard lists and the concept of equating those lists to divine, primal, and arcane works. I'm curious about what the revamped bard spell list looks like.
There were comments earlier that bards no longer need a spell list above 5th level spells but that precludes bard specific spells or spells shared with sorcerers or warlocks that are not on the other lists. If nothing else it's still a flavor list that takes up a small part of a page instead of using a sidebar.
I'm not a fan of the capstone being "here's two more spells you are required to know" but it's not that bad either other than being massively restricted in usage by spell slots. Some capstones see a lot of use while this one is likely to struggle with competition for the slot from other 9th level spells in a very limited number of available slots.
Valor, lore, and glamor bards haven't changed much other than some basic improvements. Jumanji dance fighting memes should be expected.
Overall seems good.