If your controller runs at 5 V, you need level translation on the TXD and RXD pins — the transceiver's logic inputs are not 5 V tolerant. The 1/1 driver/receiver count is standard for a single CAN node; one bus node per package.
Surface-mount only; no through-hole option. The DRG4 suffix indicates lead-free (RoHS) plating and a green molding compound.
For dual-sourcing, the SN65HVD230D (same die, different reel suffix) is a direct drop-in; the SN65HVD231D offers a standby mode with lower quiescent current but otherwise identical pinout and ratings.