RAID is not a substitute for a backup.
What you want is a backup
Yes, your HDD will hold back your SSD. Like all RAID-1's you can only write at the speed of the slowest device. Windows' can balance reads across both, but is pretty primitive at doing it.
[Edit]
Some clarification:
As per 1 and 2 RAID provides redundancy but anything other than hardware failure affecting your SSD will also be copied on to the RAID mirror (accidental deletion, corruption, viruses, etc.). It may guard you against losing hours of work if your drive dies but won't guard against losing months of work if you accidentally press "Delete".
For a typical home user scenario creating a normal backup (not RAID) from your SSD to your HDD is sufficient. For more important things, an external cloud backup can augment your system. A proper backup and version control solution will be perfectly capable of backing up every change, every second, if that's what you want.
Two SSDs in RAID + an external backup may be a hypothetical ideal solution but somewhat excessive for most users.